Oracle PL/SQL/System Tables Views/dba outlines

Материал из SQL эксперт
Перейти к: навигация, поиск

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>