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