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 / subrahmanyam.k
Null is not a charcter,unapplicable and not space. we can't
applicable or compare to another. so the final output is "ELSE"
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to get each name only once from an employee table?
what are the advantages of using stored procedures? : Sql dba
what is the difference between truncate and delete statement? : Transact sql
what is the difference between inner and outer join? Explain with example. : Sql dba
What are the constraints available in sql?
How to read xml file in oracle pl sql?
Why is sharding used?
Can two tables have same primary key?
What is the main reason behind using an index?
What is #table in sql?
What is the usage of nvl function?
what are the different type of normalization? : Sql dba
What is an index in sql with example?
What are different types of indexes?
Which command is used to delete a trigger?