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 sqlservr exe?

697


What is sql constant?

677


How do you use a while loop in pl sql?

720


What is the difference between a subquery and a join?

702


What is delimiter in pl sql?

741






How do I run a sql script?

727


Can we use ddl statements in stored procedure sql server?

723


What is group function in sql?

751


How does join work in sql?

727


How can I see all tables in sql?

727


What does closing a cursor do?

985


What are the different ddl commands in sql?

739


Which one is faster ienumerable or iqueryable?

657


What are pl sql procedures?

701


What is the difference between row level and statement level trigger?

725