SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can I use decode( decode...)...)

498839Jun 7 2006 — edited Jun 7 2006

Hi,

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 5 2006

Added on Jun 7 2006

7 comments

407 views