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 sql*plus?
How do I create a memory optimized filegroup?
Are null values same as that of zero or a blank space?
What are the types of dbms?
How does left join work in sql?
what are the authentication modes in sql server? How can it be changed? : Sql dba
how to get a list of indexes of an existing table? : Sql dba
What is identity column in sql server?
What is interval partition?
Why use stored procedures?
What is java sql driver?
What is PL/SQL Records?
Why do we use set serveroutput on?
Are stored procedures faster than queries?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?