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

Is ms sql is free?

1020

How do I enable sql encryption?

1030

when is the use of update_statistics command? : Sql dba

1049

What is memory optimized table?

1043

what are the type of locks ? : Sql dba

965

Does a join table need a primary key?

953

Why are cursors used?

1122

What is the difference between microsoft sql and mysql?

960

What does joining a thread mean?

1019

What does t sql mean?

944

What is ttitle and btitle?

1062

How do I use google cloud in sql?

1084

What is the plv (pl/vision) package offers?

1050

what are all types of user defined functions? : Sql dba

1042

Is it possible to sort a column using a column alias?

1047