ORA_DECODE

Declaration

ORA_DECODE(condition, value1, return_val1, value2, return_val2, ... valuen, return_val, omit_val)

Description

The ORA_DECODE() function is equivalent to the DECODE() function in Oracle databases.

The function works as follows:

IF condition = value1
THEN RETURN(return_value1)
ELSIF condition = value2
THEN RETURN(return_value2)
......
ELSIF condition = value_n
THEN RETURN(return_value_n)
ELSE RETURN(default_value)
END IF

Examples

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 |
+------+--------------+-------------+--------+