The answer will be "not equal" because when two null values are

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 / arup ratan banerjee

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

Answer Posted / arup ratan banerjee

The answer will be "not equal"
because when two null values are compared then it Returns
False.

Is This Answer Correct ?

1 Yes

8 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is #table in sql?

994

How can we make an if statement within a select statement?

957

What's the difference between a primary key and a clustered index?

946

What is sql injection vulnerability?

868

How many developers work on postgresql?

912

How do I save a stored procedure?

945

What is a Mapplet?

1057

Differentiate between pl/sql and sql?

1068

Is sqlite thread safe?

990

What is a database event trigger?

1078

What are types of joins?

905

What is dynamic sql in pl sql?

978

What is sql trigger example?

997

What is oracle and pl sql?

1077

What's the difference between inner join and left join?

946