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 do you delete data from a table?
explain the difference between myisam static and myisam dynamic. : Sql dba
What are the basic sql commands?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
What is pl sql in oracle?
how to select first 5 records from a table? : Sql dba
State some properties of relational databases?
Where the sql database files are stored?
what is a materialized view? : Sql dba
What is sharding in sql?
What's the difference between inner join and left join?
what is user defined functions? : Sql dba
What is the non-clustered index in sql?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What do you mean by query optimization?