select nvl( '', 'Yes '''' is null' ) "Evaluate" : NVL « Char Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Char Functions
  3. NVL

select nvl( '', 'Yes '''' is null' ) "Evaluate"

  
SQL>
SQL>  select nvl( '', 'Yes '''' is null' ) "Evaluate"
  2      from dual
  3    /
Evaluate
--------------
Yes '' is null

1 row selected.

SQL>
SQL> --








Related examples in the same category

1.NVL: Returns a substitute (some other value) if a value is null
2.NVL: Supply an NVL default that is of a different datatype
3.NVL: Provide default value for NULL
4.Use NVL() to convert number columns and date columns
5.NVL() deals with date value
6.Combine nvl and to_char
7. nvl( e2.ename, 'NO BOSS! PARTY TIME!' )
8.Use nvl in a function
9.Use TRUNC function in NVL function
10.This will fail, because the datatypes of the two arguments are different
11.Accommodate the datatype difference by placing a TO_CHAR function around the LAST_STOCK_DATE
12.Use NVL to check nullment in PL/SQL
13.Use Nvl function in math calculation for null value