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
- 12085 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / roopesh kumar
In term of oracle block should be like as........
SQL> declare
2 l1 number := null;
3 l2 number :=null;
4 begin
5 if l1=l2 then
6 dbms_output.put_line ('equal');
7 elsif l1<>l2 then
8 dbms_output.put_line ('not equal');
9 else
10 dbms_output.put_line ('else');
11 end if;
12 end;
13 /
else
PL/SQL procedure successfully completed.
Answer is as shown at end of block ELSE.
because u can't compare a null value to other null.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What is cascade in sql?
What is the difference between syntax error and runtime error?
What is difference between inner join and self join?
What is coalesce sql?
Can a primary key be a foreign key?
Does user triggers have entry for trigger with compilation errors?
How to Execute a Package in PL/SQL.?
Does truncate require commit?
What is a nested table in word?
What do you mean by rowid?
how to add a new column to an existing table in mysql? : Sql dba
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What is java sql package?
What are the types of optimization?
What is a relationship and what are they?
