CONVERT converts the string argument from one character set to another one. Syntax: CONVERT(string,destination_set, source_set) The source_set argument specifies the character set of the stored data in the database if ‘string’ is a column name, or the character set of
Oracle Home
For Everything Oracle and more