cast(12.98 as number(2)) : CAST « Conversion Functions « Oracle PL / SQL






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

cast(12.98 as number(2))

  

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>








Related examples in the same category

1.CAST() convertS one built-in data type (cast) into another
2.Cast null as timestamp
3.Cast string to date type before comparison
4.cast(null as date )