Mega Code Archive

 

Categories / Oracle PLSQL / Conversion Functions

 

CONVERT() converts between two different character sets The returned values data type is VARCHAR2

Syntax: CONVERT(<character_expression>, <target_charset> [,<source_charset>]) SQL> SQL> SQL> SQL> SELECT   2     CONVERT ('Ä', 'US7ASCII')  ascii_a   3  FROM dual; A - Z