Answer / anil kumar jampana

else
bz, null is an undefined value

Answer / roopesh kumar

In term of oracle block should be like as........

SQL> declare
2 l1 number := null;
3 l2 number :=null;
4 begin
5 if l1=l2 then
6 dbms_output.put_line ('equal');
7 elsif l1<>l2 then
8 dbms_output.put_line ('not equal');
9 else
10 dbms_output.put_line ('else');
11 end if;
12 end;
13 /
else

PL/SQL procedure successfully completed.

Answer is as shown at end of block ELSE.
because u can't compare a null value to other null.

Answer / sdp

The message() function has not been declared in the block.
If it would have been declared then answer would be 'ELSE'

Answer / subrahmanyam.k

Null is not a charcter,unapplicable and not space. we can't
applicable or compare to another. so the final output is "ELSE"

Answer / 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;
/

Answer / ramesh

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

Answer / arup ratan banerjee

The answer will be "not equal"
because when two null values are compared then it Returns
False.

What is the difference between explicit and implicit cursors in oracle?

0 Answers  

Do we need commit after truncate?

0 Answers  

display records from 5 to 9 using rowid or rownum

5 Answers   Agile Software,

Mention what are different methods to trace the pl/sql code?

0 Answers  

how to create a table index in mysql? : Sql dba

0 Answers  

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;

10 Answers  

What is a left inner join?

0 Answers  

What are different types of sql commands?

0 Answers  

Can 2 queries be executed simultaneously in a distributed database system?

0 Answers  

What is the reports view in oracle sql developer?

0 Answers  

What is information schema in sql?

0 Answers  

Explain the difference between triggers and constraints?

0 Answers