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 acid property in database? : Sql dba
What is program debugging?
What is a file delimiter?
What is pl sql in oracle?
Why stored procedures are faster than query?
What type of database is cloud sql?
What is the need of merge statement?
Is there a 64 bit version of ssms?
Show the two pl/sql cursor exceptions.
What is data manipulation language?
What is online transaction processing (oltp)?
What is difference between rank () row_number () and dense_rank () in sql?
What is trigger in pl sql with examples?
Is pl sql a programming language?
What is package in pl sql with an examples?