Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>