what is difference between Replace and Translate

answer :

• Both Replace and Translate are single row functions in Oracle.
• The Replace Function replaces single character with multiple characters.
• But in Translate function replaces single character with single character only.
• Replace changes the record in Database.But Translate won't change it the Database content is not changed.
• Replace used for String and Translate used for character.