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
Why does sql need a server?
what is the difference between cluster and non cluster index? : Sql dba
What is keys and its types?
What is autocommit sql?
What is out parameter used for eventhough return statement can also be used in pl/sql?
Can %notfound return null after a fetch?
What are the types of operators available in sql?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What is Collation Sensitivity ? What are the various type ?
Which command is used to call a stored procedure?
Is sql a scripting language?
Why do we need pl sql?
What is trigger in pl sql?
What are its different types of dbms?
How can we implement rollback or commit statement in a trigger?