I'm using Oracle 9.2.
I would like to write an sql select statement that collects the ID and DATA fileds of a table and if the DATA filed contains NULL it gets the content of the DATA2 filed.
So I would like to create one select statement instead of these two:
select id, data from mytable where data is not null;
select id, data2 from mytable where data is null;
Is it possible with one select statement?