CAST(x AS type_name): Converts a value in x from one data type to another specified in type_name : Cast « Data Type « Oracle PL / SQL






CAST(x AS type_name): Converts a value in x from one data type to another specified in type_name



SQL> -- CAST(x AS type_name): Converts a value in x from one data type to another 
specified in type_name.
SQL> select cast('1234' as Number) from dual;

CAST('1234'ASNUMBER)
--------------------
                1234

SQL>
           
       








Related examples in the same category