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 to add new employee details in an employee_details table with the following details
Can we write dml inside a function in sql server?
Can a trigger call a stored procedure?
What is server name sql?
When should I use nosql database?
Is coalesce faster than isnull?
Explain character-manipulation functions?
What is primary and foreign key?
What is sql query limit?
what is msql? : Sql dba
What is nosql db?
Is a view faster than a stored procedure?
What is data type in database?
How do I remove all records from a table?
How do I use google cloud in sql?