How to view tables in Oracle

In oracle, you can view tables by the following different methods/queries.

1- select * from user_objects where object_type = 'TABLE';
you need to input object type in CAPs

2-Select * from tabs;

3-Select * from User_TABLES;

4-Select * from DBA_TABLES (you must have logged in as DBA to view this)

5-Select * from all_all_tables;

6-Select * from dict (in order to get all the tables in the metadata)

No comments:

Post a Comment