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!

IF-ELSIF PROBLEM...

554439Jan 22 2007 — edited Jan 22 2007
CREATE OR REPLACE PROCEDURE proc_test1 IS
BEGIN
IF (TRUE AND NULL ) THEN
DBMS_OUTPUT.PUT_LINE ('first condition ');
ELSIF NOT(TRUE AND NULL ) THEN
DBMS_OUTPUT.PUT_LINE ('second condition ');
ELSIF (TRUE AND TRUE ) THEN
DBMS_OUTPUT.PUT_LINE ('third condition ');
END IF;
END proc_test1;

hi xprt..

the second condition is true...rite
NOT(TRUE AND NULL ) ===>>> true
but m not getting it...the output as "second conditon"

but only third condition...

why?... m i missing something..??

Regards...

Dichan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2007
Added on Jan 22 2007
16 comments
936 views