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
- 12175 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
what are the security recommendations while using mysql? : Sql dba
What is difference between rank () row_number () and dense_rank () in sql?
Does sql*plus also have a pl/sql engine?
what is table? : Sql dba
What are sql constraints?
What is a temporal table?
what are the authentication modes in sql server? How can it be changed? : Sql dba
how to do backup entire database? : Transact sql
What are tables and fields in the database?
Explain the types of joins in sql?
What is tuple in sql?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
Why trigger is used in sql?
Can we join 3 tables in sql?
What do you mean by “trigger” in sql?
