select coalesce( null, '', 'A' ) : COALESCE « Conversion Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Conversion Functions
  3. COALESCE

select coalesce( null, '', 'A' )

 
SQL>
SQL> select coalesce( null, '', 'A' )
  2  from dual;
C
-
A

1 row selected.

SQL>
SQL> --








Related examples in the same category

1.COALESCE() returns the first non-null expression in the expression list
2.select coalesce( null, sysdate )