Oracle PL/SQL/System Tables Views/dba outlines

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

Query dba_outlines table

   <source lang="sql">

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>

</source>