set serveroutput on; DECLARE D INTEGER :=NULL; E INTEGER :=NULL; BEGIN

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

Question Posted / sureka

22 Answers
50973 Views
TCS, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is scalar function?

999

what are tables and fields? : Sql dba

988

What is a primary key sql?

990

What do you mean by dbms? What are its different types?

949

What is sql partition function?

1116

explain primary keys and auto increment fields in mysql : sql dba

899

When sql appeared?

1022

What is date functions?

961

How to connect a sql*plus session to an oracle server?

1079

Mention what are different methods to trace the pl/sql code?

1102

What version is sql?

964

How can we link a sql database to an existing android app?

979

Why is normalization important?

971

What is normalization in sql?

962

explain advantages of innodb over myisam. : Sql dba

1082