Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 14605 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / uma
The answer will be "else"
declare
L1 number := null;
L2 number :=null;
begin
if L1=L2 then
dbms_output.put_line ('equal');
elsif L1<>L2 then
dbms_output.put_line ('not equal');
else
dbms_output.put_line ('else');
end if;
end;
/
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between stored procedure and view?
What are different joins used in sql?
Explain the rollback statement?
what is not null constraint? : Sql dba
What are the topics in pl sql?
Is sqlite thread safe?
What is scope and visibility in PL/SQL?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
How to run sql statements with oracle sql developer?
how to calculate expressions with sql statements? : Sql dba
What is sql table?
How do I view stored procedures?
What is recursive join in sql?
Which is faster subquery or join?
What is string data type in sql?
