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
- 14438 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 many triggers can be applied on a table?
what is rollback? : Sql dba
What is prepared statement in sql?
The select into statement is most often used to create backup copies of tables or for archiving records?
What is a sql statement?
Can you load data into multiple tables at once? : aql loader
What has stored procedures in sql and how we can use it?
How to look at the current sql*plus system settings?
What is sql*loader and what is it used for? : aql loader
What is a data definition language?
Explain the significance of the & and && operators in pl sql.
Is oracle and sql same?
How to select 10 records from a table?
How bulk collect improves performance?
How do I save a sql query?
