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
What is sql and how does it work?
Is postgresql a nosql database?
What are the disadvantages of not performing database normalization?
what is the difference between char and varchar data types? : Sql dba
What type of database is cloud sql?
How do we use distinct statement? What is its use?
What are sql functions? Describe in brief different types of sql functions?
What is a temporal table?
What is tuple in sql?
How do I count duplicates in sql?
How delete a row in sql?
What are procedures used for?
What is the difference between left join and right join?
what is a database lock ? : Sql dba
What is a schema? How is it useful in sql servers?