Tuesday, December 30, 2008

Oracle 10g: Show All Tables Command


...at times when we need to list out all the tables in our database..this command saves us a lot of time...


select owner, table_name, tablespace_name
from dba_tables
group by owner,table_name, tablespace_name