66 lines
2.0 KiB
SQL
66 lines
2.0 KiB
SQL
@@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
|