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
- 12176 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 is the difference between subquery and correlated query?
Explain the difference between drop and truncate commands in sql?
Why we use stored procedure instead of query?
What do you understand by case manipulation functions?
Is primary key is clustered index?
what are the differences among rownum, rank and dense_rank? : Sql dba
How to take user input in pl sql?
How many sql statements are used?
What is rename command in sql?
How to change the order of columns in Oracle SQL Plus ?
Is mariadb nosql?
define join and explain different type of joins? : Sql dba
What are the different types of joins in sql?
Is sql free?
What is sqlerrd?
