What is the result, when NULL is compared with NULL?
Answer Posted / sant
In oracle the below eg will help you to clear this:
DECLARE
D INTEGER :=NULL;
E INTEGER :=NULL;
BEGIN
IF (D = E) THEN
dbms_output.put_line('PASS);
ELSE
dbms_output.put_line('FAIL');
END IF;
END;
It will alwayz return FAIL.
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
What is blind sql injection?
What do you know by pl/sql cursors?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
How can you select unique records from a table?
What is the difference between function and procedure in pl/sql?
What is the use of desc in sql?
Which join condition can be specified using on clause?
What is difference between pl and sql?
What is a trigger in sql?
What is a design view?
How do I debug a stored procedure?
Is delete faster than truncate?
how does a local variable is defined using t-sql? : Transact sql
what are sequences
What is sqlcommand?