What is the result, when NULL is compared with NULL?

Answer Posted / abhishek jaiswal

Decode will return true if we compare null to null value.
select decode(commission_pct,null,0) from employees

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is varchar example?

566


what is rollback? : Sql dba

585


Can a view be mutating? If yes, then how?

569


What does desc stand for?

584


What is a table?

563






define sql update statement ? : Sql dba

561


What is a function in oracle pl sql?

532


how to increment dates by 1 in mysql? : Sql dba

539


What is trigger in sql and its types?

528


How to create an array in pl/sql?

575


Can we use ddl statements in stored procedure sql server?

508


What is difference between hql and native sql?

571


What is the use of index in hive?

544


How insert into statements in sql?

586


Why is sql*loader direct path so fast?

593