DECLARE v1 NUMBER; v2 NUMBER; BEGIN IF v1 = v2 THE

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

Question Posted / kuldeep123

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

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

How to run pl sql program in mysql?

1020

How to pipe multiline string to isql?

1005

Is pl sql still used?

975

Does normalization improve performance?

1038

What is a record in a database?

1062

How to get unique records from a table?

972

Why are aggregate functions called so?

946

How do you sort in sql?

1026

Does google use sql?

959

What is the starting oracle error number?

1053

what is clause? : Sql dba

1060

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1015

Why sql query is slow?

997

What is the difference between cluster and non-cluster index?

1108

Can we call stored procedure in function?

957