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 ?
- 7 Answers
- 12091 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
Define overloaded procedure?
What is indexes?
What are triggers and its uses?
What are the subsets of sql?
How long will it take to learn pl sql?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
Is ms sql is free?
How to raise user-defined exception with custom sqlerrm ?
Which sql statement is used to return only different values?
explain normalization concept? : Sql dba
How can you get sql*loader to commit only at the end of the load file? : aql loader
what's the difference between a primary key and a unique key? : Sql dba
What is difference between procedure and trigger?
Is full outer join same as cross join?
How does postgresql compare to "nosql"?
