Query dba_outlines table : dba_outlines « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. dba_outlines

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
------------------------------ ------------------------------
JAVA2S                         OUTLINE_1
JAVA2S                         OUTLINE_2
JAVA2S                         OUTLINE_3
JAVA2S                         MYOUTLINE

SQL>

 

Related examples in the same category