CodesJava

Easy learning with example program codes

CONVERT function in Oracle

CONVERT is one of the vital string/char functions of Oracle. It is used to convert a string from one character set to another. The CONVERT function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i.
Syntax:

CONVERT( string, char_set_to , char_set_from )

Parameters:
string: It is used to specify the string to convert.
char_set_to: It is used to specify the character set to convert to.
char_set_from: It is used to specify the character set to convert from.

Example:

CONVERT ( 'Ä Ê Í Õ Ø U', 'US7ASCII', 'WE8ISO8859P1' )

Output:
‘A E I ? ? U’
Explanation:
The required string is converted from ISO 8859-1 West European 8-bit character set to US 7-bit ASCII character set.

Please follow and like us:
error









Copyright © 2019 CodesJava DMCA.com Protection Status