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
- 14086 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 sqlite need a server?
How to sort the rows in sql.
Is truncate ddl or dml?
What is the difference between clustered and non-clustered indexes?
What is join view in sql?
Which software is used for pl sql programming?
when MSQL8.0 is in market
How much ram can sql express use?
What is rowid in sql?
Can delete statement be rollbacked?
What is the location of pre_defined_functions.
What do you understand by pl/sql packages?
What are sql indexes?
What is coalesce sql?
what is a join? : Sql dba
