objects

How will you see the objects in a schema?
vangogpeterAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
If connected to the database as the schema owner:
select object_name, object_type from user_objects;

or:
select object_name, object_type from dba_objects where owner='SCHEMA_NAME';
0
 
vangogpeterAuthor Commented:
select object_name,object_type from user_objects;
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.