Create an outline and query user_outlines table : outline « User Previliege « Oracle PL / SQL






  1. Oracle PL / SQL
  2. User Previliege
  3. outline

Create an outline and query user_outlines table

 
SQL>
SQL>
SQL> create or replace outline outline_1
  2  for category CAT_1
  3  on select * from dual
  4  /

Outline created.

SQL>
SQL> select category, name, sql_text
  2    from user_outlines
  3   order by category, name
  4  /

CATEGORY                       NAME                           SQL_TEXT
------------------------------ ------------------------------ --------------------------------------------------------------------------------
CAT_1                          OUTLINE_1                      select * from dual
CAT_2                          OUTLINE_2                      select * from dual
CAT_2                          OUTLINE_3                      select * from dual A
DICTIONARY_PLANS               MY_OUTLINE                     select * from all_objects
MYCATEGORY                     MYOUTLINE                      select empno, ename from emp where empno > 0

SQL>
SQL>








Related examples in the same category

1.Alter outline name
2.Alter outline to change the category
3.Create an outline