Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>