else bz, null is an undefined value

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 / anil kumar jampana

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

Answer Posted / anil kumar jampana

else
bz, null is an undefined value

Is This Answer Correct ?

8 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sql not null constraint?

1037

What are the two different parts of the pl/sql packages?

1087

What are the basic techniques of indexing?

1061

What are the commands used in sql?

1079

what is a materialized view? : Sql dba

1061

How to look at the current sql*plus system settings?

1149

What is on delete restrict?

1000

Why we use triggers in mysql?

992

How to create your own reports in sql developer?

1019

What is the maximum number of triggers, you can apply on a single table?

998

What are the different types of dbms?

1016

Is sql sequential or random?

1034

What are sql ddl commands?

1090

What is $$ in sql?

990

Can I create table without primary key?

997