Mega Code Archive
Categories
/
Oracle PLSQL
/
Conversion Functions
Cast(null as date )
SQL> SQL> select cast(12.98 as number(2)) example1 2 , cast('oak' as char(10) ) example2 3 , cast(null as date ) example3 4 from dual; EXAMPLE1 EXAMPLE2 EXAMPLE3 ---------- ---------- ---------- 13 oak SQL>