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

2 votes188 views4 answers
Check timezone of mysql database
SQL
11 votes188 views2 answers
Having in sql
SQL
11 votes175 views2 answers
MySQL DISTINCT
SQL
10 votes176 views2 answers
Forgot my mysql password mac
SQL
2 votes181 views1 answer
How to find constraints on a table in oracle
SQL
0 vote185 views1 answer
Str_to_date sql server
SQL
0 vote161 views1 answer
Mysql create table columns with spaces
SQL
0 vote220 views2 answers
How to get max from each department in sql
SQL
3 votes185 views1 answer
Mssql remove column
SQL
1 vote176 views1 answer
Postgres regex remove special characters
SQL