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

Answer Posted / 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.

Is This Answer Correct ?    12 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use sql statements in pl/sql?

578


What are operators available in sql?

583


How do I install sql?

517


What is character functions?

552


How many sectors are in a partition?

552






Is primary key a clustered index?

531


How do I send sql query results to excel?

575


how do you know the version of your mysql server? : Sql dba

503


What is a primary key? Explain

538


What is the use of primary key?

535


what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

496


what are tables and fields? : Sql dba

573


how to present a past time in hours, minutes and seconds? : Sql dba

551


What are synonyms in sql?

530


What is spool?

588