Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to see only oracle owned objects...

818663Dec 21 2010 — edited Dec 21 2010
hi,

if i want to see only oracle owned objects (i.e. procedures and packages) which are created by oracle when the database was created where can i see these objects but not including users created.....


is there anythign called
sys.obj$
or anyother table for this purpose...

what si teh data dictionary table and do we have any table or object to see all the objects in data dictionary....
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 18 2011
Added on Dec 21 2010
2 comments
96 views