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.

Is sql scripting language?

0 Answers  

how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used

11 Answers   UST,

Is left join inner or outer by default?

0 Answers  

How do you explain an index?

0 Answers  

what are the types of join and explain each? : Sql dba

0 Answers  

How do you retrieve the last N records from a table?

10 Answers  

What are different joins used in sql?

0 Answers  

What are user defined functions?

0 Answers  

What is Data Concarency and Consistency?

1 Answers  

Can we use out parameter in function?

4 Answers   Infosys,

Give the structure of the procedure ?

1 Answers  

What is pl sql package?

0 Answers