Oracle decode

DECODE(X, D1, R1, D2, R2, D3, R3, ..., Rx)
/*
if X = D1 then return R1
else if X = D2 then return R2
else if X = D3 then return R3
...
else return Rx
*/

Similar codes

4 votes221 views2 answers
Tsql utf to local time
SQL
1 vote220 views1 answer
Check if mysql is installed
SQL
0 vote231 views1 answer
Alter table engine mysql
SQL
0 vote228 views1 answer
How to search query in python3 sqlite3
SQL
11 votes205 views1 answer
How to get ddl for materialized view
SQL
0 vote220 views1 answer
Sql last 3 rows
SQL
1 vote212 views1 answer
Sql server read uncommitted
SQL
2 votes223 views1 answer
Sql server: select column values as comma separated string
SQL
3 votes224 views2 answers
Get current year sql
SQL
1 vote215 views1 answer
Sql server locks
SQL