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!

ELSE IF and ELSIF

S_27Jul 4 2006 — edited Jul 4 2006
Hi all,

I want to know if there is any advantage in using ELSIF from ELSE IF.

Consider

Case 1:

If x = y then
s1;
else if x=z then
s2;
else if x=a then
s3;
else
s4;
end if;

Case 2:

If x = y then
s1;
elsif x=z then
s2;
elsif x=a then
s3;
else
s4;
end if;

What is the big difference between these two cases (except code length) ? Please let m e know if there is any major difference.

Thanks,
H.S
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 1 2006
Added on Jul 4 2006
5 comments
677 views