CAST function in Oracle

by

CAST is one of the vital Conversion functions of Oracle. It is used to convert a datatype to another. The CAST function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i.

Syntax: 

CAST ( {expression | ( subquery ) | MULTISET ( subquery ) } AS type_name )

Example: 

select CAST( '26-Jun-2019' AS VARCHAR2(50) )
from dual;

Explanation:
The date will be converted into a VARCHAR2(50) value.