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
Why left join is used in sql?
Why plvtab is considered as the easiest way to access the pl/sql table?
How can I make sql query run faster?
What is data profiling in sql?
What are its different types of dbms?
how to create a new table by selecting rows from another table in mysql? : Sql dba
How many types of functions are there in sql?
How exception is different from error?
What is mdb stand for?
When are we going to use truncate and delete?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
how to rename an existing table in mysql? : Sql dba
What is the difference between delete and truncate statement in sql?
How is debugging done?
Is pl sql useful?