oracle characterset convert - ghdrako/doc_snipets GitHub Wiki

CONVERT(text, to_charset, from_charset)

UPDATE example_table
  SET text_column=CONVERT(text_column, 'WE8ISO8859P1', 'UTF8');