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






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

select coalesce( null, sysdate )

 
SQL>
SQL> select coalesce( null, sysdate )
  2  from dual;
COALESCE(
---------
16-JUN-08

1 row selected.

SQL>
SQL>
SQL> --








Related examples in the same category

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