I have a query in oracle..looking at returning a numeric value of 1 if a column is not NULL and 0.
some folks said that it would be similar to SQL but my query doesn't work.
So the value I want to change is Col2. Set to 1 if the there is anything in Col2, and 0 if it is NULL.
If Col2 is NOT NULL THEN 1
Else 0 NewColName,