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






Query user_outlines table

 
SQL>
SQL> create or replace outline my_outline
  2  for category my_category
  3  on select * from all_objects
  4  /

Outline created.

SQL>
SQL> select name, category, sql_text from user_outlines
  2  /

NAME                           CATEGORY                       SQL_TEXT
------------------------------ ------------------------------ --------------------------------------------------------------------------------
MY_OUTLINE                     MY_CATEGORY                    select * from all_objects
OUTLINE_3                      CAT_2                          select * from dual A
OUTLINE_1                      CAT_1                          select * from dual
OUTLINE_2                      CAT_2                          select * from dual
MYOUTLINE                      MYCATEGORY                     select empno, ename from emp where empno > 0

SQL>
SQL>
SQL>

 








Related examples in the same category