|
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>
|