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!

DECODE Function

653402Aug 4 2008 — edited Aug 4 2008

Hi Guys,

I am a newbie to this forum as well as to ORACLE database. As i need to travel very long distance, i have decided to take your peoples help along with me. I hope i can get it from this forum. Well, coming to my requirement,

DECODE Is similar to IF-THEN-ELSE. Am i right ? But i am unable to understand the following code.

select decode (nvl (count (invst), 0), 0, 'n', 'y')

what it actually doing ?

Inputs are welcome !

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 1 2008

Added on Aug 4 2008

10 comments

1,390 views