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.
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.
No one has followed this question yet.