@@header

/*
*
*  Author     : Vishal Gupta
*  Purpose    : Display bug fixes
*  Versions   : 11.1 and above
*  Parameters : 1 - search string (
*
*  Revision History:
*  ===================
*  Date       Author        Description
*  ---------  ------------  -----------------------------------------
*  01-JUL-14  Vishal Gupta  Added bugno to the search criteria 
*  01-MAY-14  Vishal Gupta  Created
*  
*/

/************************************
*  INPUT PARAMETERS
************************************/
UNDEFINE searchstring
DEFINE searchstring="&&1"  

COLUMN  _searchstring     NEW_VALUE  searchstring       NOPRINT

set term off
SELECT DECODE('&&searchstring','','%',UPPER('&&searchstring'))   "_searchstring"
FROM DUAL;
set term on


PROMPT *****************************************************************
PROMPT *  Bug Fixes
PROMPT *  
PROMPT *  Input Parameters
PROMPT *  - Search String    = '&&searchstring'
PROMPT *****************************************************************

COLUMN bugno                     HEADING "BUG"                      FORMAT 999999999
COLUMN value                     HEADING "Value"                    FORMAT 9999
COLUMN is_default                HEADING "Default"                  FORMAT 99999
COLUMN optimizer_feature_enable  HEADING "Optimizer|Feature|Enable" FORMAT a9
COLUMN event                     HEADING "Event"                    FORMAT 9999999
COLUMN sql_feature               HEADING "SQL Feature"              FORMAT a35
COLUMN description               HEADING "Description"              FORMAT a90


SELECT s.bugno
     , s.value
     , s.is_default
     , s.optimizer_feature_enable
     , s.event
     , s.sql_feature
     , s.description
  FROM v$system_fix_control s
 WHERE UPPER(s.bugno)                    LIKE '&&searchstring'
    OR UPPER(s.optimizer_feature_enable) LIKE '&&searchstring'
    OR UPPER(s.sql_feature)              LIKE '&&searchstring'
    OR UPPER(s.description)              LIKE '&&searchstring'
;

UNDEFINE searchstring

@@footer