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
How do I run a sql query in pgadmin 4?
What is the file extension for sql database?
What is the primary key?
Which type of cursor is used to execute the dml statement?
What is duration in sql profiler trace?
what is unique key constraint? : Sql dba
Explian rowid, rownum? What are the psoducolumns we have?
What are different types of queries in sql?
What is the importance of sqlcode and sqlerrm?
What is dml with example?
How can you load microsoft excel data into oracle? : aql loader
What is recursive stored procedure?
How you improve the performance of sql*loader? : aql loader
what is sql? : Sql dba
how to drop an existing table in mysql? : Sql dba