Help!! I need to recreate a package on different instance, but i don't know what the view that will give me the coding for the package...
Thanks
Printable View
Help!! I need to recreate a package on different instance, but i don't know what the view that will give me the coding for the package...
Thanks
USER_/ALL_/DBA_SOURCE
SELECT text FROM user_source
WHERE name = 'MY_PACK'
AND type = 'PACKAGE'
ORDER BY line;
SELECT text FROM user_source
WHERE name = 'MY_PACK'
AND type = 'PACKAGE BODY'
ORDER BY line;