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 / 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
How does sql*loader handles newline characters in a record? : aql loader
How does cross join work?
what is acid property in database? : Sql dba
How delete all records from table in sql?
What is anonymous block in sql?
What is data types in sql?
explain the options of myisamchk to improve the performance of a table. : Sql dba
What is sap sql anywhere?
What is an implicit commit?
What is clustered and nonclustered index in sql?
How do we accept inputs from user during runtime?
What is sql profiler in oracle?
How to create a menu in sqlplus or pl/sql?
what is foreign key? : Sql dba
What are the advantages of stored procedure?