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
51743 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

How do you modify a table in sql?

1116

How do you update a table in sql?

981

Can we create table inside stored procedure?

947

What is union and union all keyword in sql and what are their differences?

1098

What is the importance of sqlcode and sqlerrm?

1345

What is crud sql?

973

How many tables can a sql database have?

972

Explain sql data types?

1085

Is trigger a stored procedure?

929

How can we optimize a sql query?

1045

What does count (*) mean in sql?

1576

What is the difference between distinct and unique in sql?

940

What does count (*) do in sql?

1003

List different type of expressions with the example.

931

What is meant by <> in sql?

962