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
14367 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 the difference between partition and index?

979

How does sql profiler work?

1011

Does oracle roll back the transaction on an error?

1006

What is the usage of the distinct keyword?

1214

What are the different types of functions in sql?

1046

Explain ttitle and btitle.

1116

What is %rowtype in pl sql?

985

Is sqlite thread safe?

1040

What is a parameter query?

1071

What are character functions in sql?

935

Can you join a table to itself?

1120

What is the difference between null value, zero, and blank space?

1196

How do you respond to dementia behavior?

963

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2490

What is difference between stored procedure and trigger?

1156