How to list all tables form a database?
I try to list all tanles from a database, I have searched for this and have not found anything. In DB2, I can use "list tables", in MySQL I can use "show tables". Does Oracle have a corresponding command to do this? Thanks.
By "all" tables you mean regardless of owner? The dba_tables is what you need to query. If less than 100%, then variations of #1 below (restricted by owner for dba_ and all_) can be used.
1) select table_name from dba/all/user_tables
A quickie query for a user is:
2) select * from tab;
("TAB is included for compatibility with Oracle version 5. Oracle Corporation recommends that you do not use this view.")
You can use tabs also...
tab will result 'View' also, but tabs not.
select table_name from tabs
Click Here to Expand Forum to Full Width