Syntax
ORA_DECODE(condition, value1, return_val1, value2, return_val2, ... valuen, return_val, omit_val)
Purpose
The functionality of ORA_DECODE() is the same as that of the DECODE() function in Oracle Database.
The mechanism of this function is as follows:
IF condition = value 1
THEN RETURN (return value 1)
ELSIF condition = value 2
THEN RETURN (return value 2)
...
ELSIF condition = value n
THEN RETURN (return value n)
ELSE RETURN (default value)
END IF
Examples
obclient> SELECT * FROM films ORDER BY ORA_DECODE(id,1,'lala',2,'mua');
+------+--------------+-------------+--------+
| id | release_year | category_id | rating |
+------+--------------+-------------+--------+
| 3 | 2015 | 3 | 9.00 |
| 4 | 2016 | 2 | 8.20 |
| 5 | 2016 | 1 | 8.40 |
| 6 | 2017 | 2 | 7.00 |
| 1 | 2015 | 1 | 8.00 |
| 2 | 2015 | 2 | 8.50 |
+------+--------------+-------------+--------+