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 primary key sql?
What are commit, rollback, and savepoint?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
What problem one might face while writing log information to a data-base table in pl/sql?
What is a sql trace file?
Are pl sql variables case sensitive?
What is a native sql query?
What is sql profiler in oracle?
What is left join example?
what are the t string functions available in tsql? : Transact sql
What is parallel hint?
Which join condition can be specified using on clause?
What are the different dcl commands in sql?
What is a join query?
How many commands are in sql?