What is the result, when NULL is compared with NULL?
Answer Posted / archana
begin
if null is null then
dbms_output.put_line('null');
else
dbms_output.put_line('not null');
end if
end;
now it will return null
it is recommended to use 'is' with null not ' ='
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how does a local variable is defined using t-sql? : Transact sql
what is a trigger in mysql? : Sql dba
Which certification is best for sql?
how to use case expression? : Sql dba
What are the types of records?
Why do you partition data?
What is the difference between microsoft access and sql?
what is the difference between a having clause and a where clause? : Sql dba
What is the current version of postgresql?
How can check sql version from command line?
what is schema? : Sql dba
Does truncate require commit?
How do I enable sql encryption?
What is lookup table in sql?
What is the limitation on the block size of pl/sql?