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

Can we use views in stored procedure?

1085

What do you think about pl/sql?

1125

Which join is default?

1015

What is partition in sql query?

1045

Explain some predefined exceptions.

1093

what are the authentication modes in sql server? : Sql dba

1121

What is sql injection vulnerability?

1005

what are all different types of collation sensitivity? : Sql dba

1029

What are the advantages of sql?

1100

What is rtm in testing?

1175

what is data manipulation language? : Sql dba

1069

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

1051

Why are aggregate functions called so?

1012

explain advantages of innodb over myisam. : Sql dba

1175

explain normalization concept? : Sql dba

1090