Hi Friends,
The sample data stored in one of the columns in the database is as follows:
SELECT *
FROM
(
SELECT 'MTC-1039195130-Elcoteq' location FROM DUAL UNION ALL
SELECT 'MTC Foxconn India' FROM DUAL UNION ALL
SELECT 'MTC_Hosiden_1798467' FROM DUAL UNION ALL
SELECT 'EMS- MTC-QISDA CORPORATION' FROM DUAL UNION ALL
SELECT 'EMS MTC-BANSHING HKG' FROM DUAL
)
In all these,i want to replace MTC with XXX.
Database Version:Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production