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

is it possible to pass an object or table to a procedure as an argument?

1057

Is sql harder than python?

1035

How insert into statements in sql?

1007

Explain what is sql?

1051

Can I learn sql in a week?

1003

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2020

How are functions and procedures called in PL/SQL?

1127

What is int identity in sql?

1055

Which are the different character-manipulation functions in sql?

984

How do you pronounce sql?

951

What is a sql statement?

899

How does sql store data?

865

Can you join views in sql?

896

What is sql injection owasp?

998

Do stored procedures prevent sql injection?

914