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 ?

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 hadoop a nosql?

571


how to decrement dates by 1 in mysql? : Sql dba

582


Explain the difference between rename and alias?

543


How can you load multi line records? : aql loader

655


What is substitution variable in pl sql?

501






How can you know that statistics should be updated?

601


what is the difference between clustered and non clustered index in sql? : Sql dba

547


How can you load microsoft excel data into oracle? : aql loader

613


what is meant by urlencode and urldocode? : Sql dba

599


what is a trigger in mysql? Define different types of trigger. : Sql dba

548


What is the difference between cluster and non-cluster index?

616


Can instead of triggers be used to fire once for each statement on a view?

537


Which sorts rows in sql?

585


how would you enter characters as hex numbers? : Sql dba

516


Is pl sql different from sql?

530