I have a table which I'm extracting data from with a SELECT statement(and outputing as a text file), there's some changes I want to make to the extracted data before it is output (not the actual data on the table).
There's column1 and column2.
column1 has some null values. I want these values to be a certain value 'NB' if they are null AND if column2 is null as well! If there is a value in column2, then these can stay null. And if column1 already has a value (is not null) then I want to display that value..
How can I go about this in PL SQL? Thanks