Oracle PL/SQL/System Tables Views/user outlines
Query user_outlines table
<source lang="sql">
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>
</source>