We help IT Professionals succeed at work.

pl/sql Nested Case Statement

syhctl
syhctl asked
on
Hi All,
I need help with a Nested Case statement for the following:
CASE WHEN (Field1) in ('ABC', 'CDE','FGH')
THEN 'Closed'
CASE WHEN (Field1) in ('IJK', 'LMN', 'OPQ')
THEN 'Open'
CASE WHEN (fIELD1) IN ('RST','UVW','XY')
THEN 'PENDING'
End
Comment
Watch Question

Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009
Commented:
no need to nest the case statements:
CASE WHEN (Field1) in ('ABC', 'CDE','FGH')
     THEN 'Closed'
     WHEN (Field1) in ('IJK', 'LMN', 'OPQ')
     THEN 'Open'
     WHEN (fIELD1) IN ('RST','UVW','XY')
     THEN 'PENDING'
End

Open in new window

Author

Commented:
Thanks Much

Explore More ContentExplore courses, solutions, and other research materials related to this topic.