CONVERT() converts between two different character sets. The returned value's data type is VARCHAR2. : CONVERT « Conversion Functions « Oracle PL / SQL

1. Oracle PL / SQL
2. Conversion Functions
3. CONVERT

CONVERT() converts between two different character sets. The returned value's 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

 

Related examples in the same category