/* traffic light effect */
SELECT 'value < 66' VALUE,'right part of gauge is green' description,'SQLDEV:GAUGE:0:15:5:10:65' gauge FROM dual
UNION
SELECT '66 <= value <= 90' VALUE,'right part of gauge is yellow' description,'SQLDEV:GAUGE:0:600:200:400:66' gauge FROM dual
UNION
SELECT '66 <= value <= 90' VALUE,'right part of gauge is yellow' description,'SQLDEV:GAUGE:60:500:200:400:90' gauge FROM dual
UNION
SELECT 'value > 90' VALUE,'right part of gauge is red' description, 'SQLDEV:GAUGE:0:500:200:400:91' gauge FROM dual;

/* workaround */
SELECT 'value < 66' VALUE,'SQLDEV:GAUGE:0:15:5:15:65' gauge FROM dual
UNION
SELECT '66 <= value <= 90' VALUE,'SQLDEV:GAUGE:0:600:200:600:66' gauge FROM dual
UNION
SELECT '66 <= value <= 90' VALUE,'SQLDEV:GAUGE:60:500:200:500:90' gauge FROM dual
UNION
SELECT 'value > 90' VALUE, 'SQLDEV:GAUGE:0:500:200:500:91' gauge FROM dual;