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
14597 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

Is it mandatory for the primary key to be given a value when a new record is inserted?

1252

What is bind reference and how can it be created?

1068

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1300

What do you mean by stored procedures?

1069

How many sql statements are used? Define them.

1081

What are tuples in sql?

1197

What does an inner join do?

1248

What is the difference between local and global temporary table?

1088

What are the sql versions?

996

What is coalesce sql?

1052

How do I kill a query in postgresql?

1185

In a distributed database system, can we execute two queries simultaneously?

1153

What are different types of sql?

1263

What is a system versioned table?

1040

What is the difference between sum and count in sql?

1036