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
- 12093 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / sdp
The message() function has not been declared in the block.
If it would have been declared then answer would be 'ELSE'
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are literals in sql server?
What is java sql driver?
what is the difference between inner and outer join? Explain with example. : Sql dba
What is the use of nvl function?
Explian rowid, rownum?
What is mutating error?
Can you sum a count in sql?
How do you respond to dementia behavior?
What is indexes?
In what condition is it good to disable a trigger?
What are the different parts of a package?
Is sql developer case sensitive?
Why stored procedures are faster than query?
What is sql used for?
how can we know the number of days between two given dates using mysql? : Sql dba
