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