-
Assuming I have a package called mypack.daemon_pac and I want to list(show) the contents of the package, is there any sql query that can show me the contents? If there are can any one please show me?
I know that you can use schema manager in OEM, but I am wondering if there is any sql command that will do this.
-
you can see the SQL text by:
select text from dba_source where name='<PACKAGE_NAME>';
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
|