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