Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between NVL, NVL2 and NULLIF
- 1 Answers
- 36770 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 is cross join example?
What is sequence in sql?
What is a function in oracle pl sql?
What packages are available to pl/sql developers?
What is the difference between clustered and non-clustered index in sql?
What is difference between sql and excel?
Explain what is an index?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
What is a unique constraint?
What is full form of rtm?
What are all the different types of indexes?
What is %type in pl sql?
-
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)
