-
to list all the procedures and packages
Hi people ! i wonder how to list all the source code for all the packages and procedures for a schema (or for all the database)
Someone knows how to do it from the sqlplus ?
Thxs a lot !!
Papik
-
select text from dba_source where owner in ('SCHEMA1', 'SCHEMA2')
-
Last edited by learning_bee; 11-11-2003 at 03:46 PM.
-
Originally posted by bhallar
select text from dba_source where owner in ('SCHEMA1', 'SCHEMA2')
... and order by owner, name, line
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|