Mega Code Archive

 

Categories / Oracle PLSQL / User Previliege

 

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>