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
14405 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 is hibernate and its relation to sql?

1123

How to create a menu in sqlplus or pl/sql?

1122

Which software is used for pl sql programming?

986

Why primary key is required?

1006

What are sql functions? Describe in brief different types of sql functions?

1102

what is a materialized view? : Sql dba

1061

What is cursor status?

1186

what is 'mysqlcheck'? : Sql dba

1012

What are sql queries used for?

1023

What is varchar data type in sql?

1082

What is index example?

1008

Why is stored procedure faster than query?

960

Is it possible to create startup or shutdown trigger for on-schema?

1029

What is nosql example?

1034

What are local and global variables and their differences?

1090