compilation error, because you should not use two times end if;

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 / ramesh

7 Answers
14364 Views
Oracle, I also Faced
E-Mail Answers

Answer Posted / ramesh

compilation error, because you should not use two times end
if;

Is This Answer Correct ?

3 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the constraints available in sql?

1044

what is schema? : Sql dba

1044

What does select top 1 do in sql?

1084

what is the difference between blob and text? : Sql dba

1008

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1034

What is native sql query?

1010

What is orm in sql?

1041

What is normalization in a database?

1150

How many postgresql users are there, worldwide?

1056

What are % type and % rowtype?

1028

What is mdf ldf and ndf?

991

what is cursor. write example of it. What are the attributes of cursor.

1377

What is scalar function?

1046

What is left join example?

940

What is foreign key and example?

927