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 ?
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
How many rows can sqlite handle?
Can we write ddl statements in functions?
What is error ora-01000: maximum open cursors exceeded
what is the difference between cluster and non cluster index? : Sql dba
Enlist the data types that can be used in pl/sql?
What is form and report?
How do you create an update query?
What does a pl/sql package consist of?
What is the location of pre_defined_functions.
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
Which is faster view or stored procedure?
what is a constraint? Tell me about its various levels. : Sql dba
explain the difference between myisam static and myisam dynamic. : Sql dba
What are the advantages of sql?
What is attribute indicator in pl sql?