Cast « Conversion Functions « Oracle PL/SQL Tutorial

15.10.1.cast(12.98 as number(2)) example1 cast('oak' as char(10) ) example2 cast(null as date ) example3
15.10.4.Cast string to date type before comparison
15.10.5.Cast null as timestamp
15.10.6.Cast table of numbers
15.10.7.Cast number to a char
15.10.8.Cast date to char
15.10.9.Cast decimal to integer

15.10.10.Cast varchar to char
15.10.11.CAST examples
15.10.12.Use Date to cast string to date type