ORA_DECODE

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

IF 条件=値1
THEN RETURN(戻り値1)
ELSIF 条件=値2
THEN RETURN(戻り値2)
......
ELSIF 条件=値n
THEN RETURN(戻り値n)
ELSE RETURN(デフォルト値)
END IF

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