Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between NVL, NVL2 and NULLIF
- 1 Answers
- 36795 Views
- CTS, Metric Stream, I also Faced
- E-Mail Answers
Answer / sushma s
NVL function substitute a value when a null value is
encountered.
NVL2: substitutes a value when a null value is encountered
as well as when a non-null value is encountered.
The syntax for the NVL2 function is:
NVL2( string1, value_if_NOT_null, value_if_null )
string1 is the string to test for a null value.
value_if_NOT_null is the value returned if string1 is not null.
value_if_null is the value returned if string1 is null.
NULLIF: NULLIF function compares expr1 and expr2. If expr1
and expr2 are equal, the NULLIF function returns NULL.
Otherwise, it returns expr1.
| Is This Answer Correct ? | 65 Yes | 2 No |
What are sql*plus environment variables?
What is the maximum size of sqlite database?
What is a sql statement?
What is a left join?
What is sql character function?
How to execute multiple sql statements in a single annonymous block irrespective of the sql statement result?
how to check myisam tables for errors? : Sql dba
Does view contain data?
What is the difference between a procedure and a function?
how to calculate the difference between two dates? : Sql dba
What is the purpose of using pl/sql?
What are all the different types of indexes?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
