oracle equivalent of mysql ifnull (no case, no if)

Question

I am looking for a quick way to do

SELECT IFNULL(columna, columnb) FROM mytable

(I have dozens of columns and don't want to write a case for each of them)

score 3 · Accepted Answer · answered Jul 14 '15 at 14:50

3

You can also use the standard COALESCE keyword, which allows you to pass it multiple parameters:

SELECT COALESCE(columna, columnb, ..., columnz) FROM mytable

answered Jul 14 '15 at 14:50

sstan

just found out about it too. And it seems a better option (standard SQL) – NotGaeL Jul 14 '15 at 14:51

score 2 · Answer 2 · answered Jul 14 '15 at 14:49

2

just found out:

SELECT nvl(columna, columnb) FROM mytable

answered Jul 14 '15 at 14:49

NotGaeL

2 Answers2