using nvl2 and decode
KSSJul 15 2009 — edited Jul 15 2009Hi Experts,
Here my requirement is if column values is null or zero it should pass zero if it is having any value it should pass value+concat a % symbol.
I tried some thing like this
select nvl2(year,concat(year,'%'),0) from sales
it is handling only null values,when i am trying with Decode i am getting ora 01722 error.
can any one help me.
Thanks
kss.