Oracle PL/SQL/Char Functions/Convert

CONVERT(x, source_char_set, dest_char_set)L Converts x from source_char_set to dest_char_set

--CONVERT(x, source_char_set, dest_char_set) Converts x from source_char_set to dest_char_set.
select convert("A B C D E", "US7ASCII", "WE8ISO8859P1") from dual;