SQL>
SQL> create or replace outline my_outline
2 for category my_category
3 on select * from dual
4 /
Outline created.
SQL>
SQL>
SQL> create or replace outline my_other_outline
2 for category "My_Category"
3 on select * from dual
4 /
Outline created.
SQL>
SQL>
SQL> select name, category, sql_text from user_outlines;
NAME CATEGORY SQL_TEXT
------------------------------ ------------------------------ --------------------------------------------------------------------------------
MY_OTHER_OUTLINE My_Category select * from dual
OUTLINE_1 CAT_1 select * from dual
OUTLINE_2 CAT_2 select * from dual
OUTLINE_3 CAT_2 select * from dual A
MYOUTLINE MYCATEGORY select empno, ename from emp where empno > 0
MY_OUTLINE MY_CATEGORY select * from dual
6 rows selected.
SQL>
SQL> exec outln_pkg.drop_by_cat( 'my_category' );
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL> select name, category, sql_text from user_outlines;
NAME CATEGORY SQL_TEXT
------------------------------ ------------------------------ --------------------------------------------------------------------------------
MY_OTHER_OUTLINE My_Category select * from dual
OUTLINE_1 CAT_1 select * from dual
OUTLINE_2 CAT_2 select * from dual
OUTLINE_3 CAT_2 select * from dual A
MYOUTLINE MYCATEGORY select empno, ename from emp where empno > 0
MY_OUTLINE MY_CATEGORY select * from dual
6 rows selected.
SQL>
SQL>
SQL> exec outln_pkg.drop_by_cat( 'MY_CATEGORY' );
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL> select name, category, sql_text from user_outlines;
NAME CATEGORY SQL_TEXT
------------------------------ ------------------------------ --------------------------------------------------------------------------------
MY_OTHER_OUTLINE My_Category select * from dual
OUTLINE_1 CAT_1 select * from dual
OUTLINE_2 CAT_2 select * from dual
OUTLINE_3 CAT_2 select * from dual A
MYOUTLINE MYCATEGORY select empno, ename from emp where empno > 0
SQL>
SQL> exec outln_pkg.drop_by_cat( 'My_Category' );
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL> select name, category, sql_text from user_outlines;
NAME CATEGORY SQL_TEXT
------------------------------ ------------------------------ --------------------------------------------------------------------------------
OUTLINE_1 CAT_1 select * from dual
OUTLINE_2 CAT_2 select * from dual
OUTLINE_3 CAT_2 select * from dual A
MYOUTLINE MYCATEGORY select empno, ename from emp where empno > 0
SQL>
SQL>