What is the result, when NULL is compared with NULL?
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / sandeep kumar
select * from dual where null=null
no row return
Is This Answer Correct ? | 1 Yes | 0 No |
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 |
Answer / divi
Null is not equal to Null
Nor
Null is equal to Null
Is This Answer Correct ? | 0 Yes | 0 No |
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 |
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 |
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 |
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
How do you optimize a stored procedure query?
table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.
What is use of trigger?
in table there r so many rows write a query which two rows r updated last two day befor?
hi sql gurus, here is my question 4 u. i wanna use triggers for sending reminder mail to all users who are registered to the site. if any one knws the code plz send me ans here : chayabs3@gmail.com thnx advance
What is oracle and pl sql?
How many columns should be in an index?
what is the different between now() and current_date()? : Sql dba
Is coalesce faster than isnull?
What is form and report?
What are different joins used in sql?