CONVERT

The Oracle and PL/SQL CONVERT function converts a string from one character set to another.

The general format is:

CONVERT(char_to_convert, new_char_set, old_char_set)

Example 1:

SELECT CONVERT('ESPAÑA', 'US7ASCII', 'WE8ISO8859P1') FROM DUAL;

returns:

ESPA?A