SQL> @sp_list_sql_profiles.sql
SQL> col category for a15
SQL> col sql_text for a70 trunc
SQL> select name, category, status, sql_text, force_matching
2 from dba_sql_profiles
3 where sql_text like nvl('&sql_text','%')
4 and name like nvl('&name',name)
5 order by last_modified
6 /
Enter value for sql_text:
old 3: where sql_text like nvl('&sql_text','%')
new 3: where sql_text like nvl('','%')
Enter value for name:
old 4: and name like nvl('&name',name)
new 4: and name like nvl('',name)
NAME CATEGORY STATUS SQL_TEXT FOR
------------------------------ --------------- -------- ---------------------------------------------------------------------- ---
PROF_dccyz592gpzpq_3994356561 DEFAULT ENABLED SELECT YES