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
- 12069 Views
- Oracle, I also Faced
- E-Mail Answers
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
What are string functions in sql?
How can you tell the difference between an index and a view?
Why is sql*loader direct path so fast?
Can we perform dml in function?
How can you load multi line records? : aql loader
What is percent sign in sql?
Is id a reserved word in sql?
Why left join is used in sql?
What is attribute indicator in pl sql?
What is the main difference between sql and pl/sql?
What is the purpose of my sql?
What is the usage of the distinct keyword?
What is keys and its types?
how to enter binary numbers in sql statements? : Sql dba
Why function is used in sql?
