Re: Pacakes, procedure, funtions

From: Jerome Vitalis <vitalismanN05P4M_at_gmail.com.invalid>
Date: 15 Oct 2007 18:05:18 GMT
Message-ID: <4713abde$0$16593$79c14f64@nan-newsreader-06.noos.net>

On Sun, 14 Oct 2007 22:34:00 -0700, imu.ice wrote:

> Hi
>
> I need to know how to view the contents of a package , procedure or
> function, trigger using SQLPLUS. By using tolls like toad we can
> directly go to the packae body and see the code.. How to see the code of
> a package, procedure or function in sqlplus??

It is not the proper group. Follow-up to comp.databases.oracle.misc

For your question, have a look at the all_source, user_source and dba_source in the documentation. Received on Mon Oct 15 2007 - 13:05:18 CDT