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>