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

i looking quick way do

select ifnull(columna, columnb) mytable 

(i have dozens of columns , don't want write case each of them)

you can use standard coalesce keyword, allows pass multiple parameters:

select coalesce(columna, columnb, ..., columnz) mytable 

coalesce keyword documentation