Decode will return true if we compare null to null value. select decode(co

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

Question Posted / abhishek jaiswal

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

Please Help Members By Posting Answers For Below Questions

what is the difference between primary key and unique key? : Sql dba

1025

How exception is different from error?

1006

define data blocks ? : Sql dba

971

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1033

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1068

What is the difference between delete and truncate statement in sql?

1056

What is the purpose of my sql?

943

What is database migration?

960

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1081

How many aggregate functions are available there in sql?

977

Is sql developer case sensitive?

985

What is the difference between inner join and natural join?

997

Do we need commit after truncate?

1072

What does the acronym acid stand for in database management?

1029

How is indexing done in search engines?

978