Oracle PL/SQL/Conversion Functions/CONVERT

Материал из SQL эксперт
Перейти к: навигация, поиск

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>