Query all_tables for owner and table_name
SQL>
SQL>
SQL> select owner, table_name
2 from all_tables where rownum < 50
3 order by owner, table_name;
OWNER TABLE_NAME
------------------------------ ------------------------------
SYS ARGUMENT$
SYS ATTRCOL$
SYS BOOTSTRAP$
SYS CCOL$
SYS CDEF$
SYS CLU$
SYS COL$
SYS COLTYPE$
SYS CON$
SYS DIR$
SYS ERROR$
OWNER TABLE_NAME
------------------------------ ------------------------------
SYS FET$
SYS FILE$
SYS ICOL$
SYS ICOLDEP$
SYS IDL_CHAR$
SYS IDL_SB4$
SYS IDL_UB1$
SYS IDL_UB2$
SYS IND$
SYS JAVAOBJ$
SYS LIBRARY$
OWNER TABLE_NAME
------------------------------ ------------------------------
SYS LOB$
SYS NTAB$
SYS OBJ$
SYS OBJAUTH$
SYS OPQTYPE$
SYS PROCEDURE$
SYS PROCEDUREINFO$
SYS PROXY_DATA$
SYS PROXY_ROLE_DATA$
SYS REFCON$
SYS SEG$
OWNER TABLE_NAME
------------------------------ ------------------------------
SYS SEQ$
SYS SOURCE$
SYS SUBCOLTYPE$
SYS SUPEROBJ$
SYS SYN$
SYS TAB$
SYS TS$
SYS TSQ$
SYS TYPED_VIEW$
SYS TYPE_MISC$
SYS UET$
OWNER TABLE_NAME
------------------------------ ------------------------------
SYS UGROUP$
SYS UNDO$
SYS USER$
SYS VIEW$
SYS VIEWTRCOL$
49 rows selected.
SQL>
Related examples in the same category