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
- 14147 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 synonyms?
what are the security recommendations while using mysql? : Sql dba
Mention what problem one might face while writing log information to a data-base table in pl/sql?
Give the order of sql select?
What is a trigger in sql?
What is trigger in sql? Explain
What is latest version of sql?
What are actual parameters and formal parameters?
Does user triggers have entry for trigger with compilation errors?
How many developers work on postgresql?
What is range partitioning?
what is column? : Sql dba
List the ways to get the count of records in a table?
What do you mean by stored procedures? How do we use it?
What is a sql statement?
