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
Are subqueries better than joins?
What is pls_integer in pl sql?
What is sqlerrm?
What is mutating error?
What is a natural join?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
What is the sql query to display the current date?
Can we debug stored procedure?
What is exception? What are the types of exceptions?
what are the advantages of using stored procedures? : Sql dba
What is the starting oracle error number?
Can you skip header records while loading? : aql loader
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
What is difference between inner join and self join?
Is sql database free?