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
Are stored procedures faster than dynamic sql?
What is meant by cursor in sql?
What is rowid in sql?
What is substitution variable in pl sql?
Describe different types of general function used in sql?
What do you understand by case manipulation functions?
What is package in pl sql with an examples?
Why is sharding used?
Which command is used to call a stored procedure?
What are the benefits of pl sql?
what is the difference between union and union all? : Sql dba
What is dense_rank?
what is oracle database ? : Sql dba
Is pl sql and postgresql same?
How to pipe multiline string to isql?