Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

USER_CATALOG view also has a synonym defined

SQL> SQL> SQL> -- USER_CATALOG view also has a synonym defined. SQL> SQL> SELECT * FROM USER_CATALOG where rownum < 10; TABLE_NAME                     TABLE_TYPE ------------------------------ ----------- ACCESS$                        TABLE ALERT_QT                       TABLE ALL_ALL_TABLES                 VIEW ALL_APPLY                      VIEW ALL_APPLY_CONFLICT_COLUMNS     VIEW ALL_APPLY_DML_HANDLERS         VIEW ALL_APPLY_ENQUEUE              VIEW ALL_APPLY_ERROR                VIEW ALL_APPLY_EXECUTE              VIEW 9 rows selected. SQL> SQL> SQL>