What is the result, when NULL is compared with NULL?

Answers were Sorted based on User's Feedback



What is the result, when NULL is compared with NULL?..

Answer / ashu_deepu

2 NULL value can not b equal.

i just want to remind some imp. point about primary key.
d condition is
1) not null n
2) unique.
since 2 null value r unique dats why we require the 1st point of not null.

Is This Answer Correct ?    1 Yes 0 No

What is the result, when NULL is compared with NULL?..

Answer / nhajare

Hi,
If you comapare null=null then it return 0 rows selected.
Check the result of this query...

select * from table_name where null=null;

Is This Answer Correct ?    1 Yes 0 No

What is the result, when NULL is compared with NULL?..

Answer / sandeep kumar

select * from dual where null=null

no row return

Is This Answer Correct ?    1 Yes 0 No

What is the result, when NULL is compared with NULL?..

Answer / naidu

NOT EQUAL AND AGAIN ANSWER IS NULL

Is This Answer Correct ?    1 Yes 0 No

What is the result, when NULL is compared with NULL?..

Answer / kishore vakiti

select * from emp where null is null;

Is This Answer Correct ?    1 Yes 0 No

What is the result, when NULL is compared with NULL?..

Answer / abhishek jaiswal

Decode will return true if we compare null to null value.
select decode(commission_pct,null,0) from employees

Is This Answer Correct ?    1 Yes 0 No

What is the result, when NULL is compared with NULL?..

Answer / divi

Null is not equal to Null
Nor
Null is equal to Null

Is This Answer Correct ?    0 Yes 0 No

What is the result, when NULL is compared with NULL?..

Answer / sureka

set serveroutput on;
DECLARE
D INTEGER :=NULL;
E INTEGER :=NULL;
BEGIN
IF (D = E) THEN
dbms_output.put_line('PASS');
ELSIF (D <> E) THEN
dbms_output.put_line('FAIL');
ELSE
dbms_output.put_line('NA');
END IF;
END;

will return NA

Is This Answer Correct ?    0 Yes 0 No

What is the result, when NULL is compared with NULL?..

Answer / archana

begin
if null is null then
dbms_output.put_line('null');
else
dbms_output.put_line('not null');
end if
end;

now it will return null
it is recommended to use 'is' with null not ' ='

Is This Answer Correct ?    0 Yes 0 No

What is the result, when NULL is compared with NULL?..

Answer / kuldeep123

DECLARE
v1 NUMBER;
v2 NUMBER;
BEGIN
IF v1 = v2
THEN
DBMS_OUTPUT.put_line ('Null comapred successfully');
ELSE
DBMS_OUTPUT.put_line ('oops u have to use ISNULL opeartor');
END IF;
END;


output : oops u have to use ISNULL opeartor

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is the difference between microsoft access and sql server?

0 Answers  


How many clustered indexes can you have?

0 Answers  


What is scope and visibility in PL/SQL?

0 Answers  


What are the different dml commands in sql?

0 Answers  


How do you create an update query?

0 Answers  






Which command is used to delete a trigger?

0 Answers  


I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS

7 Answers   Polaris,


Explain the working of foreign key?

0 Answers  


what are Dynamic SQL statements?

9 Answers  


How to count the no of records of a table without using COUNT function?

11 Answers   TCS, Tesco,


What is pl sql commands?

0 Answers  


what is the difference between truncate and drop statements? : Sql dba

0 Answers  


Categories