|  | Decode function in Sql - Definition, syntax, examplesDecode function in Sql - Definition, syntax, examples ... The above examples shows using a Decode function. The logic similar to - if DEPT_NO = '065' THEN 0.5*10000 if DEPT_NO = '075' THEN 0.6*10000 if DEPT_NO = '024' THEN 0.7*10000 ELSE 0.8*10000 The ... www.oraclesql-plsql.com |  |