TRANSLATE Function in SQL?

What is TRANSLATE Function in SQL?

• Replaces the Characters in a string with required set of characters.
• It Replaces one character at a time.
• It Translate character by character

Example:

SELECT ' TECHBLOG' STRING, TRANSLATE('TECHBLOG','TECH','SQL') TRANSLATE FROM DUAL;

WHERE ENAME LIKE'%A%';