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 Statement with multiple statements in THEN clause

603591Aug 3 2010 — edited Aug 3 2010
Is there a syntax something like:

Case

When A=1
Then B := 2 and C := 3

When A=2
Then B := 4 and C := 5

Else B := 6 and C := 7

End Case;

where the then clause can have multiple assignments?

Also, how do you mark input as code on this forum?

TIA,

Far Farley
This post has been answered by SomeoneElse on Aug 3 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 31 2010
Added on Aug 3 2010
6 comments
13,083 views