Wednesday, January 3, 2018

List All Tables in Oracle Apps

List All Tables in Oracle:
   1. Viewing Tables Owned by Current user
     select table_name,owner
     from user_tables
     order by owner,table_name;

   2. Viewing Tables Accessible by Current User
     select table_name,owner
     from all_tables
     order by owner,table_name;
 
   3. Viewing All Tables
     select table_name,owner
     from dba_tables
     where owner='schema_name'
     order by owner,table_name;

No comments:

Post a Comment