Can I use decode( decode...)...)
498839Jun 7 2006 — edited Jun 7 2006Hi,
Can I use decode function inside decode function.
It seem doesn't work. Please help
decode(lv.RANK||' / '||
decode('('||lv.ONE_YR_PCT||'%)', '(%)','N/A','('||lv.ONE_YR_PCT||'%)'),
'0 / (0%)','N/A', lv.RANK )
Thanks