Oracle String/Char Function - Oracle/PLSQL CONVERT Function

• « Previous
• Next »

This Oracle tutorial explains how to use the Oracle/PLSQL CONVERT function.

CONVERT(x,to_char_set[,from_char_set]) converts x from from_char_set to to_char_set.

Syntax

The syntax of the CONVERT function is:

CONVERT( string1 , to_char_set , [ from_char_set ] )

string1 is the string to be converted.

to_char_set is the character set to convert to.

from_char_set is the character set to convert from.

We can use the following character sets:

Example

SQL>-- w ww .jav  a2s. c om
SQL> select convert('A  ', 'US7ASCII') from dual;

CONV
----
A  Z

SQL> select convert('A  ', 'US7ASCII', 'WE8ISO8859P1') from dual;

CONV
----
A  ?

SQL>

• Next »
• « Previous