Answer / kmbkrishnan

if we check a Null value with another Null value as equal,
the result will be false.

Answer / anil kumar abbireddy

NOT EQUAL AND AGAIN ANSWER IS NULL

Answer / affan shemle

It is absolutely perfect to compare NULL with NULL. It
yields the result NULL. For those who are saying the result
is FALSE they are taking the answer from IF THEN ELSE. In
all the above answers supported by IF Statement there is a
catch. The result of IF is a Boolean. A Boolean can hold
TRUE, FALSE or NULL. So when you compare NULL vs NULL as a
condition of IF THEN, it returns NULL so the controller goes
to ELSE skipping the IF. Makes sense???
/
AFFAN SHEMLE

Answer / pavan_1981

i dont know how u can compare a null value with another
null value.i dont find any operator for doing that.

Answer / sant

In oracle the below eg will help you to clear this:

DECLARE
D INTEGER :=NULL;
E INTEGER :=NULL;
BEGIN
IF (D = E) THEN
dbms_output.put_line('PASS);
ELSE
dbms_output.put_line('FAIL');
END IF;
END;

It will alwayz return FAIL.

Answer / talent pool

NULL Is An Unknown Value
So We Couldn't Compare it With Other One.This Is Pure
Correct Answer.

declare @d int
Set @d =null
declare @r int
Set @r=null
if @d=@r
Print 'Hi'
Else
Print 'Summa Vilayadatha'

Answer / a.jyothsna

One null value is not equal to another null value.

Answer / guest

The answer is NULL vs NULL = FALSE

Answer / kirankumar.vangeti

Null is neither equal to null nor it is not equal to null.
Any comparison to null is evaluated to null.

Answer / brahma

Null means unknown values, but do not compare both null
values

Is a foreign key always unique?

0 Answers  

how to create temparary sequence

2 Answers   TCS,

What is the unique index?

0 Answers  

What is pivot table in sql?

0 Answers  

What is the difference between sql and t sql?

0 Answers  

Are left and right joins the same?

0 Answers  

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

How to execute a stored procedure?

0 Answers  

what does myisamchk do? : Sql dba

0 Answers  

what is the boundary line in varrays?

1 Answers   HCL,

What is pl sql collection?

0 Answers