question

OracleApprender avatar image
OracleApprender asked

Can we change function, procedure and package names using oracle commands ?

Please let me know whether we can change the names of package, procedure and functions by using oracle commands similar to tables. Thank you in advance.

oraclecommands
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KillerDBA avatar image
KillerDBA answered

You can.

A Guide to Synomyms and RENAME

Note, you can also use synomyms instead of renaming things.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

HillbillyToad avatar image
HillbillyToad answered

The synonym method will give you most of the desired behavior, but your program will still exist with the original name. You need to drop the object and re-create it with the name you want.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.