Alter outline to change the category : outline « User Previliege « Oracle PL / SQL






Alter outline to change the category

 
SQL>
SQL> create or replace outline my_outline
  2  for category my_category
  3  on select * from all_objects
  4  /

Outline created.

SQL>
SQL>
SQL> alter outline my_outline change category to dictionary_plans
  2  /

Outline altered.

SQL> select name, category, sql_text from user_outlines
  2  /

NAME                           CATEGORY                       SQL_TEXT
------------------------------ ------------------------------ --------------------------------------------------------------------------------
MY_OUTLINE                     DICTIONARY_PLANS               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>

 








Related examples in the same category

1.Alter outline name
2.Create an outline
3.Create an outline and query user_outlines table