Advertisement
tmmdv

bug.sql

Aug 22nd, 2018
1,042
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.61 KB | None | 0 0
  1. SET term off
  2.  
  3. var descr varchar2(200)
  4. EXEC :descr := UPPER('%' || '&1' || '%')
  5.  
  6. col bugno                           format 999999999
  7. col VALUE                           format 999
  8. col sql_feature                     format a40
  9. col optimizer_feature_enable        format a10 heading 'Opt|features'
  10.  
  11. SET term ON echo off
  12.  
  13. SELECT bugno, VALUE, sql_feature, description, optimizer_feature_enable
  14.   FROM v$session_fix_control
  15.  WHERE session_id = userenv('sid')
  16.    AND (UPPER(description) LIKE :descr OR to_char(bugno) LIKE :descr OR optimizer_feature_enable LIKE :descr)
  17.  ORDER BY optimizer_feature_enable, bugno;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement