Is there any query to see the source code of a package ? Please let me know if any exists. Thank you in advance.
Jonah Harris answered this question:
Instead of 'VIEW', use the parameter 'PACKAGE':
SELECT DBMS_METADATA.GET_DDL('PACKAGE','<package_name>') FROM DUAL;
You will also want to fiddle with the max column size parameter. Example:
Search for the GET_DDL method described there and note the use of:
'SET LONG <n>'
As you can see from my own answer to my own question, the path of least resistance is to get a decent Oracle coding tool. SQL Tools 1.5 is free and does the trick. You can look at all the definitions in your database using the object list browser.
No one has followed this question yet.