Oracle PL/SQL/System Tables Views/user outlines

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>