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
14173 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 do I order columns in sql?

927

Write the alter statement to enable all the triggers on the t.students table.

1083

What is the difference between the sql*loader and import utilities? : aql loader

996

Explain what is a subquery ?

1131

what is data manipulation language? : Sql dba

962

How does a self join work?

1016

What do you think about pl/sql?

964

What is a procedure in pl sql?

1149

Why query optimization is needed?

872

how to add a new column to an existing table in mysql? : Sql dba

1017

What are the types of queries in sql?

1038

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1102

tell us something about heap tables. : Sql dba

1062

Can two tables have same primary key?

926

If a cursor is open, how can we find in a pl/sql block?

1118