PL/SQL: Procedure to copy package with another name

Here’s simple procedure build upon custom listagg implementation (see Custom listagg function using cursor to bypass ORA-01489) that creates a copy of existing package with a new name.It comes very handy when you have several versions of package (say production and development) and constantly switch between them.It simply obtains package definition and body and then […]