Pacakes, procedure, funtions

#1

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??

Thanks
Imran..

#2

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

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Pacakes, procedure, funtions

comp.databases.oracle.marketplace comp.databases.oracle.marketplace

Pacakes, procedure, funtions - 10-15-2007 , 12:34 AM

Re: Pacakes, procedure, funtions - 10-15-2007 , 01:05 PM