Skip to Main Content

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!

Case Expression question

Eric999Oct 9 2018 — edited Oct 10 2018

Here's two case expressions that return the same results. Which one is best? I like the second once since there's less code.

1.)

CASE columnname1
   WHEN 1
      THEN
         CASE
             WHEN columnname2 = 'N'
                THEN
                   CASE
                      WHEN columnname3 = columnname4
                         THEN 1
                      ELSE 0
                   END
             ELSE 0     
         END
   ELSE 0     
END

2.)

CASE
   WHEN columnname1 = 1
    AND columnname2 = 'N'
    AND columnname3 = columnname4
      THEN 1
   ELSE 0
END

Comments
Post Details
Added on Oct 9 2018
22 comments
1,107 views