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

   <source lang="sql">

--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;

      </source>