Oracle SQL: the Essential Reference

CONVERT

CONVERT (string, dest_char_set[, source_char_set])

Converts a character string from one character set to another.

Parameters

string

Specifies a character string to convert.

dest_char_set

Specifies the name of the destination character set.

source_char_set

Specifies the name of the source character set. This parameter defaults to the database character set.

Example

SQL> SELECT CONVERT(CHR(194) || CHR(133) || CHR(64) || CHR(213)
  2                 || CHR(137) || CHR(131) || CHR(133),
  3                 'US7ASCII','WE8EBCDIC37C')
  4  FROM dual;

CONVERT
-------
Be Nice