--001

SELECT v8_sys_check.*
      ,LTRIM(TRIM(name)) NameLeft
--	  ,DECODE(MOD(rownum,2), 0, 'WhiteLine', 'GreyLine') cssclass
--	  ,rownum Position
FROM   (SELECT V8_SYS_CHECK.*
--              ,MOD(rownum,2) LINENUM
	    FROM   v8_sys_check
	   ) v8_sys_check
--WHERE  (v8_sys_check.category = 'oracle parameter' OR v8_sys_check.category = 'global oracle parameter')
--AND     TRIM(status) = 'red'
WHERE    TRIM(status) = 'red' AND v8_sys_check.category <> 'tablespaces'
