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
14408 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

Where the sql database files are stored?

1014

What are tables and fields?

1033

what are myisam tables? : Sql dba

1032

What is %s in sql?

1015

what is user defined functions? : Sql dba

1031

How many types of triggers exist in pl/sql?

1072

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1049

What is the use of function in sql?

1094

Is the primary key an index?

1026

What is left inner join in sql?

1044

What is a primary key sql?

1041

Is sqlite free?

971

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1074

What is a crud api?

954

What is pl sql and why it is used for?

1113