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
- 14348 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / uma
The answer will be "else"
declare
L1 number := null;
L2 number :=null;
begin
if L1=L2 then
dbms_output.put_line ('equal');
elsif L1<>L2 then
dbms_output.put_line ('not equal');
else
dbms_output.put_line ('else');
end if;
end;
/
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How do you remove duplicates without using distinct in sql?
What found sql?
How can one get sql*loader to commit only at the end of the load file? : aql loader
What does an inner join do?
How delete all data from table in sql?
how to get @@error and @@rowcount at the same time? : Sql dba
Is inner join faster than left join?
what are the advantages of sql ? : Sql dba
what is the difference between clustered and non clustered index in sql? : Sql dba
how can you create an empty table from an existing table? : Sql dba
What is on delete restrict?
What are the advantages of indexing?
Which join is like an inner join?
what are ddl statements in mysql? : Sql dba
How do I save a sql query?
