Mahacode Free Source Code

 
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>