Pacakes, procedure, funtions

[i***@gmail.com]

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

[Jerome Vitalis]

Post by i***@gmail.com
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.