Oracle PL/SQL/System Tables Views/ALL CATALOG — различия между версиями
Admin (обсуждение | вклад) м (1 версия) |
Admin (обсуждение | вклад) м (1 версия) |
(нет различий)
|
Текущая версия на 13:01, 26 мая 2010
ALL_CATALOG view provides a list of objects that you have been granted access to, as well as those that you own
<source lang="sql">
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>
</source>