Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to view PL/SQL code for a procedure?
DA Morgan wrote:
> 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.
A 9i new feature, so not for the OP.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/whatsnew.htm#970843
Sameer:
8i is obsolete, only marginally supported by Oracle if you've kept up your support contract.
jg
-- @home.com is bogus. Cure AIDS, diabetes and cancer! http://www.signonsandiego.com/uniontrib/20060725/news_1b25ftc.htmlReceived on Tue Jul 25 2006 - 15:37:46 CDT