The answer will be "else" declare L1 number := null;

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 ?

Question Posted / uma

7 Answers
14083 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

Please Help Members By Posting Answers For Below Questions

What are the subsets of sql?

1037

What are the ddl commands?

948

What is sql indexing?

963

Why we use join in sql?

915

Can a composite key be null?

910

What is an invalid partition table?

959

what are the different tables present in mysql? : Sql dba

923

what is clause? : Sql dba

1003

List out the acid properties and explain?

904

What is the use of <> sql?

931

What are sql data types?

948

what are date and time data types? : Sql dba

930

Can you have more than one key in a database?

890

Does pl/sql support create command?

1044

Why we use cross join?

888