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
- 14353 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
Does varchar need length?
How do I run a query in pl sql developer?
How do you write a complex sql query?
What is the usage of the distinct keyword?
what are the 'mysql' command line arguments? : Sql dba
What is file based approach?
Do prepared statements prevent sql injection?
What is normalization in sql?
What is the reports view in oracle sql developer?
Why do we need unique key in a table?
Is hadoop a nosql?
What is the difference among union, minus and intersect?
What are % type and % rowtype?
What is rownum?
explain access control lists. : Sql dba
