Mega Code Archive

 

Categories / Oracle PLSQL / PL SQL

 

DECODE() to compare 1 to 2, and since they are not equal 3 is returned

SQL> SQL> --DECODE() to compare 1 to 2, and since they are not equal 3 is returned: SQL> SQL> SELECT DECODE(1, 2, 1, 3)   2  FROM dual; DECODE(1,2,1,3) ---------------               3 SQL>