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
- 12168 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 a unique key?
What is a pl/sql block?
What are pl sql procedures?
what is the difference between a local and a global temporary table? : Sql dba
Explain the uses of control file.
Can you rollback after commit?
how to calculate the difference between two dates? : Sql dba
What problem one might face while writing log information to a data-base table in pl/sql?
Mention what plvcmt and plvrb does in pl/sql?
What is the syntax to add a record to a table?
What is the current version of postgresql?
What is microsoft t sql?
Why sql query is slow?
What is an inner join sql?
What are the limitations of sql express?
