Oracle PL/SQL/System Tables Views/dba outlines
Версия от 13:45, 26 мая 2010; (обсуждение)
Query dba_outlines table
SQL>
SQL> create or replace outline outline_1
2 for category CAT_1
3 on select * from dual
4 /
Outline created.
SQL>
SQL>
SQL> create or replace outline outline_2
2 for category CAT_2
3 on select * from dual
4 /
Outline created.
SQL>
SQL>
SQL> create or replace outline outline_3
2 for category CAT_2
3 on select * from dual A
4 /
Outline created.
SQL>
SQL>
SQL> select owner, name from dba_outlines where rownum < 50;
OWNER NAME
------------------------------ ------------------------------
sqle OUTLINE_1
sqle OUTLINE_2
sqle OUTLINE_3
sqle MYOUTLINE
SQL>