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!

Nested Decode

CopterJul 10 2012 — edited Jul 10 2012

Hi All-
I have a requirement where i need to convert a case statement into a nested decode statement here is the scenario

CASE WHEN CD_FAM_01 = 'Y' THEN 'N'
WHEN CD_FAM_02 = 'Y' THEN 'Y'
WHEN CD_FAM_03 = 'Y' THEN 'Y'
WHEN CD_FAM_04 = 'Y' THEN 'Y'
WHEN CD_FAM_05 = 'Y' THEN 'Y'
WHEN CD_FAM_01 IS NULL AND CD_FAM_02 IS NULL AND CD_FAM_03 IS NULL AND CD_FAM_04 IS NULL AND CD_FAM_05 IS NULL THEN 'N'
WHEN CD_FAM_01 = 'N' AND CD_FAM_02 = 'N' AND CD_FAM_03 = 'N' AND CD_FAM_04 = 'N' AND CD_FAM_05 = 'N'THEN 'N' END

I am facing a torrid time in converting this statement can you help me here

This post has been answered by ChrisAyre on Jul 10 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 7 2012

Added on Jul 10 2012

3 comments

7,218 views