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
- 12118 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 happens if you no create privilege in a database? : Sql dba
What are the ways on commenting in a pl/sql code?
How do you use a while loop in pl sql?
Are views faster than queries?
Can we insert in view in sql?
What are the benefits of pl/sql packages?
Explain the working of foreign key?
How do I view a view in sql?
what are myisam tables? : Sql dba
what is a table in a database ? : Sql dba
How to display the records between two range in Oracle SQL Plus?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
How many databases can sql express handle?
What is dml statement?
Mention what plvcmt and plvrb does in pl/sql?
