Data Dictionary Scope : DBA_Tables « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. DBA_Tables

Data Dictionary Scope

  
SQL>
SQL>
SQL> select owner, table_name, tablespace_name
  2  from dba_tables
  3  where owner in ('SCOTT', 'HR') and rownum < 50
  4  order by owner, tablespace_name, table_name;

OWNER                          TABLE_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------ ------------------------------
HR                             DEPARTMENTS                    USERS
HR                             EMPLOYEES                      USERS
HR                             JOBS                           USERS
HR                             JOB_HISTORY                    USERS
HR                             LOCATIONS                      USERS
HR                             REGIONS                        USERS
HR                             COUNTRIES

7 rows selected.

SQL>

   
  

Related examples in the same category