Skip to content

Coder Tutorial

Menu
  • Home
  • HTML
  • CSS
  • PHP
  • SQL
  • MySQL
  • JS
  • PL/SQL
  • Python
  • Java
  • Oracle
Home
PL/SQL
PL/SQL NVL

PL/SQL NVL

Oracle PL/SQL NVL Function

The NVL function compares two expressions. If exp1 and exp2 are not equal then return exp1. If exp1 and exp2 are equal the function returns NULL.

The NVL Function syntax:

NVL( string, value )

value is returned if string is null.

Example 1:

Select NVL(e.bonus, 0) From employees e;

Example 2:

Select NVL(customer_email, 'n/a') From customers;

Tutorials

  • PL/SQL Tutorial
  • PL/SQL Blocks
  • PL/SQL Variables
  • PL/SQL Control structures
  • PL/SQL Collections and Records
  • PL/SQL Cursors
  • PL/SQL Stored Procedures
  • PL/SQL Functions
  • PL/SQL Packages
  • PL/SQL Exception Handling
  • PL/SQL Triggers
  • PL/SQL If-Then-Else Statement
  • PL/SQL For Loop
  • PL/SQL While Loop
  • PL/SQL Case Statement
  • PL/SQL Varray
  • PL/SQL Nested Table
  • PL/SQL Indexed Arrays
  • PL/SQL Record
  • PL/SQL Examples
  • Oracle PL/SQL Functions
  • PL/SQL Interview Questions

Recent Posts

  • Java Polymorphism
  • Java Encapsulation
  • Java Abstraction
  • PostgreSQL ERROR: cannot begin/end transactions in PL/pgSQL
  • PostgreSQL Column must appear in the GROUP BY clause
  • PostgreSQL Column specified more than once
  • PostgreSQL Create database, Alter database examples
  • PostgreSQL Create schema syntax, Alter schema
  • PostgreSQL Create database user, alter and drop username
  • PostgreSQL Alter table name. Modify column name
Coder Tutorial Copyright © 2025. | Privacy Policy
Back to Top ↑