Answer Posted / babu
nullif basically allows you to compare 2 expressions of
same datatype and return null if both are equal. else it
would return the first expression.eg:
nullif(10,10) returns null
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
what is oltp (online transaction processing)? : Sql dba
Is it possible to link two groups inside a cross products after the cross products group has been created?
When is the explicit cursor used ?
What are the uses of merge?
How to get each name only once from an employee table?
How bulk collect improves performance?
Explain the uses of a database trigger?
Can we join two tables without common column?
When to use inner join and left join?
In a distributed database system, can we execute two queries simultaneously?
discuss about myisam key cache. : Sql dba
explain normalization concept? : Sql dba
What is rank dense_rank and partition in sql?
What is dynamic sql in pl sql?
What are the different parts of a package?