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>