--Example 1
SELECT 'Complete IT Professional' as SAMPLE_TEXT,
TRANSLATE('Complete IT Professional', 'o', 'X') as TRANSLATE_TEST
FROM dual;

--Example 2
SELECT 'Complete IT Professional' as SAMPLE_TEXT,
TRANSLATE('Complete IT Professional', 'Is', 'SW') as TRANSLATE_TEST
FROM dual;

--Example 3
SELECT 'Complete IT Professional' as SAMPLE_TEXT,
TRANSLATE('Complete IT Professional', 'IsC m', 'SWx2q') as TRANSLATE_TEST
FROM dual;

--Example 4
SELECT 'Complete IT Professional' as SAMPLE_TEXT,
TRANSLATE('Complete IT Professional', 'omsi', '12') as TRANSLATE_TEST
FROM dual;

--Example 5
SELECT 'Complete IT Professional' as SAMPLE_TEXT,
TRANSLATE('Complete IT Professional', 'omsi', '') as TRANSLATE_TEST
FROM dual;

--Example 6
SELECT 'Complete IT Professional' as SAMPLE_TEXT,
TRANSLATE('Complete IT Professional', 'x', 'a') as TRANSLATE_TEST
FROM dual;

--Example 7
SELECT 'Complete IT Professional' as SAMPLE_TEXT,
REPLACE('Complete IT Professional', 'let', 'sip') as REPLACE_TEST,
TRANSLATE('Complete IT Professional', 'let', 'sip') as TRANSLATE_TEST
FROM dual;

http://www.databasestar.com/oracle-translate/

A few examples of the TRANSLATE function.

Oracle TRANSLATE Function

sql, Oracle

SQL