Mega Code Archive
ALL_CATALOG view provides a list of objects that you have been granted access to, as well as those that you own
<![CDATA[
SQL>
SQL>
SQL>
SQL> --Querying the ALL_CATALOG view provides a list of objects
SQL> --that you have been granted access to, as well as those that you own.
SQL>
SQL>
SQL> SELECT * FROM ALL_CATALOG where rownum <10;
OWNER TABLE_NAME TABLE_TYPE
------------------------------ ------------------------------ -----------
SYS ICOL$ TABLE
SYS CON$ TABLE
SYS UNDO$ TABLE
SYS PROXY_ROLE_DATA$ TABLE
SYS FILE$ TABLE
SYS UET$ TABLE
SYS IND$ TABLE
SYS SEG$ TABLE
SYS COL$ TABLE
9 rows selected.
SQL>
SQL>
SQL>
]]>