What is the result, when NULL is compared with NULL?
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
How to run sql statements with oracle sql developer?
Why function is used in sql?
What is exception? What are the types of exceptions?
What is group by in sql?
What is primary key sql?
Can you join views in sql?
What is sql profiling in oracle?
What are the various levels of constraints?
What is cursor and why it is required?
Why functions are used in sql?
How do I view a view in sql?
What are the operators used in select statements?
Why do we use sqlite?
How do you write a subquery?
How do you update a table in sql?