Custom Search : Technical Guides Sybase Oracle UNIX Javascript

Technical Guides

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.


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.

Oracle : Related Topics

Sybase Web Site
Sybase iAnywhere Mobile Web Site
Oracle Enterprise Web Site

Get the latest Rocket99 news and tech tips via

Site Index About this Guide to Sybase, Oracle, and UNIX Contact Us Advertise on this site

Copyright © 2019 Stoltenbar Inc All Rights Reserved.