else bz, null is an undefined value

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 / anil kumar jampana

7 Answers
14084 Views
Oracle, I also Faced
E-Mail Answers

Answer Posted / anil kumar jampana

else
bz, null is an undefined value

Is This Answer Correct ?

8 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is $$ in sql?

940

Is sql the best database?

913

Explain the difference between sql and mysql.

1001

What is basic structure of pl sql?

986

How would you pass hints to the sql processor?

920

Describe types of sql statements?

990

how many tables will create when we create table, what are they? : Sql dba

1019

How do I run a sql trace?

906

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1786

Define the select into statement.

993

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

985

Is it possible to include an insert statement on the same table to which the trigger is assigned?

956

What is over () in sql?

892

What is trigger and how to use it in sql?

954

What is replication id?

886