Advertisement
Guest User

Untitled

a guest
Jun 16th, 2016
199
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.87 KB | None
  1. /* traffic light effect */
  2. SELECT 'value < 66' VALUE,'right part of gauge is green' description,'SQLDEV:GAUGE:0:15:5:10:65' gauge FROM dual
  3. UNION
  4. SELECT '66 <= value <= 90' VALUE,'right part of gauge is yellow' description,'SQLDEV:GAUGE:0:600:200:400:66' gauge FROM dual
  5. UNION
  6. SELECT '66 <= value <= 90' VALUE,'right part of gauge is yellow' description,'SQLDEV:GAUGE:60:500:200:400:90' gauge FROM dual
  7. UNION
  8. SELECT 'value > 90' VALUE,'right part of gauge is red' description, 'SQLDEV:GAUGE:0:500:200:400:91' gauge FROM dual;
  9.  
  10. /* workaround */
  11. SELECT 'value < 66' VALUE,'SQLDEV:GAUGE:0:15:5:15:65' gauge FROM dual
  12. UNION
  13. SELECT '66 <= value <= 90' VALUE,'SQLDEV:GAUGE:0:600:200:600:66' gauge FROM dual
  14. UNION
  15. SELECT '66 <= value <= 90' VALUE,'SQLDEV:GAUGE:60:500:200:500:90' gauge FROM dual
  16. UNION
  17. SELECT 'value > 90' VALUE, 'SQLDEV:GAUGE:0:500:200:500:91' gauge FROM dual;
Advertisement
RAW Paste Data Copied
Advertisement