Using TRANSLATE function

[Priya Venkatesan]

Hi,
Can someone explain why the output of the TRANSLATE function is as follows?
TRANSLATE ('mISSISSIppI', 'Mis', 'mIS') gives MISSISSIppI.
I thought translation takes place character by character. However, here 'M' is not found in 'mISSISSIppI'.

[Remar Uy]

I tried the function in 8.1.7.0.0 and it results to:

  
SQL> select TRANSLATE ('mISSISSIppI', 'Mis', 'mIS') from dual;
TRANSLATE('
-----------
mISSISSIppI
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
PL/SQL Release 8.1.7.0.0 - Production
CORE    8.1.7.0.0       Production
TNS for Solaris: Version 8.1.7.0.0 - Production