Of Interest
Be responsible for your future
Enter the USA legally!
Visa, Green Card, Citizenship, Passport
Consultation Services
|
Oracle
»
PL-SQL
»
NVL
»
NULL
NVL Function
This function allows you to deal with nulls in arithmetic expressions, in addition to making reports more user-friendly.
Example:
select first_name, last_name, nvl( spouse_name, 'Not Married' )
from employee ;
In this example, the string "Not Married" is displayed if the spouse_name is null.
|
|
|
Get the latest Rocket99 news and tech tips via
|
