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
- 12166 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
Can we use ddl commands in pl sql?
What is rank dense_rank and partition in sql?
How many types of indexes are there in sql?
Write a query to display the current date in sql?
what are the performance and scalability characteristics of mysql? : Sql dba
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
How do I partition a table in sql?
Write the alter statement to enable all the triggers on the t.students table.
What is the order of sql select?
What is the difference between joins?
Can a varchar be a primary key?
What is trigger in pl sql?
Can we join same table in sql?
how many ways to get the current time? : Sql dba
Which type of cursor is used to execute the dml statement?
