Oracle Packages and Stored Procs

Today I needed to look at an Oracle package, but the only client tool I had access to was Squirrel Sql.  

You can see the source code for a package (or stored proc or function) with by querying either of these tables: all_source, user_source, dba_source.

select text from all_source where type='PACKAGE BODY' and name ='MYPACKAGE'

or

to see the entire package

select text from all_source where name='MYPACKAGE'