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

How to return an array from java to pl/sql?

1146

What language is oracle sql developer?

1024

what is auto increment? : Sql dba

1015

What is sqlcontext?

1090

What is oracle sql developer?

1069

Explain exception handling in pl/sql?

1042

what is rdbms? : Sql dba

1018

how to shut down the server with 'mysqladmin'? : Sql dba

1017

Can you have more than one trigger on a table?

1004

Is sqlite thread safe?

1058

what is a stored procedure? : Sql dba

1140

What is a natural join sql?

992

Does mysql support pl sql?

1178

What is the most common sql injection tool?

1047

Explain the working of primary key?

1102