Null is not a charcter,unapplicable and not space. we can't applicabl

declare
l1 number := null;
l2 number :=null;
begin
if l1=l2 then message('equal');
else
if l1<>l2 then message('not equal');
else
message('else');
end if;
end if;
end;
What will be the output ?

Question Posted / subrahmanyam.k

7 Answers
14359 Views
Oracle, I also Faced
E-Mail Answers

Answer Posted / subrahmanyam.k

Null is not a charcter,unapplicable and not space. we can't
applicable or compare to another. so the final output is "ELSE"

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to avoid duplicate records in a query?

999

Will truncate release space?

940

Show the cursor attributes of pl/sql.

1042

What is the importance of sqlcode and sqlerrm?

1345

Explain scalar functions in sql?

1054

What is AUTH_ID and AUTH_USER in pl/sql ?

2180

What is sql constant?

1020

Why is theta join required?

1138

Enlist the characteristics of pl/sql?

1791

Is left join faster than join?

1045

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

955

How do I view tables in mysql?

970

Can a key be both primary and foreign?

986

What is dcl in sql?

951

what are numeric data types? : Sql dba

1056