SELECT TRANSLATE('EDUCATION', 'E', 'U') FROM DUAL;

TRANSLATE
----------
UDUCATION

SELECT TRANSLATE('EDUCATION', 'E', 'OO') FROM DUAL;

TRANSLATE
----------
ODUCATION

SELECT TRANSLATE('EDUCATION', 'AEIU', 'OOOO') FROM DUAL;

TRANSLATE
----------
ODOCOTOON

SELECT TRANSLATE('EDUCATION', 'AIU', 'OOOO') FROM DUAL;

TRANSLATE
----------
EDOCOTOON

SELECT TRANSLATE('EDUCATION', 'E') FROM DUAL;
 SELECT TRANSLATE('EDUCATION', 'E') FROM DUAL
        *
 ERROR at line 1:
 ORA-00909: invalid number of arguments

SELECT TRANSLATE('EDUCATION', 'E', NULL) FROM DUAL;

T
-
 

SELECT TRANSLATE('EDUCATION', 'E', ' ') FROM DUAL;

TRANSLATE
----------
 DUCATION

SELECT TRANSLATE('EDUCATION', 'EU', 'O') FROM DUAL;

TRANSLATE
----------
ODCATION

SELECT TRANSLATE('EDUCATION', 'AEIOU', 'E') FROM DUAL;

TRANSLATE
----------
DCETN

SELECT TRANSLATE('EDUCATION') FROM DUAL;
 SELECT TRANSLATE('EDUCATION') FROM DUAL
    *
 ERROR at line 1:
 ORA-00909: invalid number of arguments

SELECT TRANSLATE('THE ULTIMATE CODEMAN', ' ', '') FROM DUAL;

T
-
 

SELECT TRANSLATE('THE ULTIMATE CODEMAN', 'O ', 'O') 
  FROM DUAL;

TRANSLATE('ORACLE
------------------
ORACLECORPORATION

Q : Determine the no. of vowels present in ‘THE ULTIMATE CODEMAN’?

Ans:

SELECT 
    UPPER('THE ULTIMATE CODEMAN') Actual, 
    LENGTH('THE ULTIMATE CODEMAN') - 
       LENGTH(TRANSLATE(UPPER('THE ULTIMATE CODEMAN'),  'BAEIOU', 'B')) Consonant
  FROM DUAL;

Q : How to remove all numbers from a given string?

Ans:

SELECT TRANSLATE('&GiveStr', 'A1234567890', 'A') Str
  FROM DUAL;

Enter value for givestr: THE123CO34DE45678MAN90

STR
-------
THECODEMAN