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

What is sql clause?

1090

what is top in tsql? : Transact sql

1171

What is an alias command?

1111

Explain aggregate functions are available there in sql?

1048

Enlist the advantages of sql.

1052

What is sql procedures and functions?

1071

Can we join two tables without common column?

1057

What is sql integrity?

1239

what does the t-sql command ident_current does? : Transact sql

1044

What do you think about pl/sql?

1115

What is %s in sql?

1075

Explain what is a column in a table?

1155

what is not null constraint? : Sql dba

1076

Is mariadb a nosql database?

1098

how to do backup entire database? : Transact sql

1191