Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET term off
- var descr varchar2(200)
- EXEC :descr := UPPER('%' || '&1' || '%')
- col bugno format 999999999
- col VALUE format 999
- col sql_feature format a40
- col optimizer_feature_enable format a10 heading 'Opt|features'
- SET term ON echo off
- SELECT bugno, VALUE, sql_feature, description, optimizer_feature_enable
- FROM v$session_fix_control
- WHERE session_id = userenv('sid')
- AND (UPPER(description) LIKE :descr OR to_char(bugno) LIKE :descr OR optimizer_feature_enable LIKE :descr)
- ORDER BY optimizer_feature_enable, bugno;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement