Re: How to view PL/SQL code for a procedure?

Sameer wrote:
> Hello,
> I am using Oracle 8i. I have created several procedure in the database.
> Once they are created, they are part of database.
> This is being part of Oracle Data Dictionary, be stored in one of the
> table.
> Can we see the code of these procedures?
> I know that it is possible using tool like SQL Developer or Toad, but
> how to do this in SQL * Plus?
> Please help.
> -Sameer

The best method with any Oracle object is:

SELECT dbms_metadata.get_ddl('<object_type>', '<object_name>') FROM dual.

This package is documented at http://tahiti.oracle.com and as $ORACLE_HOME/rdbms/admin/dbmsmeta.sql.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org