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
- 12123 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 character functions in sql?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
Can you join a table to itself?
what is index? : Sql dba
Is left join same as inner join?
what's the difference between a primary key and a unique key? : Sql dba
What is pl/sql table? Why is it used?
What is equi join in sql?
What is difference between pl and sql?
What does where 1 1 mean in sql?
What is sql*loader and what is it used for?
How can we make an if statement within a select statement?
How can I tell if sql is running?
How many scalar data types are supported in pl/sql?
What plvcmt and plvrb does in pl/sql?
