Skip to Main Content
Forums

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!

List of tables in a schema

809045Nov 16 2010 — edited Nov 16 2010
I have see list of tables in a schema. But i am not able to see.

i tried using

select * from tabs.
SELECT * FROM USER_TABLES
select table_name from all_tables

I need to see only tables belong to a schema.

help me
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 14 2010
Added on Nov 16 2010
5 comments
101,453 views