decode to check if given column is not null
450482Feb 5 2008 — edited Feb 6 2008Hi
I was trying to write a decode statement that follows:
if col1 is not null then do something.
How can I write decode to have not null as an arguement?
...decode(col1, not null, 'This has a value')...
I do not want to check if null. I want to check if not null.