Query all_tables for owner and table_name : ALL_TABLES « System Tables Views « Oracle PL / SQL






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

1.Get all tables that you have been granted access to