Oracle PL/SQL/Conversion Functions/CONVERT
CONVERT() converts between two different character sets. The returned value"s data type is VARCHAR2.
<source lang="sql">
Syntax: CONVERT(<character_expression>, <target_charset> [,<source_charset>])
SQL> SQL> SQL> SQL> SELECT
2 CONVERT ("Ä", "US7ASCII") ascii_a 3 FROM dual;
A - Z
</source>