Syntax
ORA_DECODE(condition, value1, return_val1, value2, return_val2, ... valuen, return_valn, omit_val)
Purpose
The functionality of ORA_DECODE() is the same as that of the DECODE() function in Oracle database.
Mechanism of this function:
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
+------+--------------+-------------+--------+