Using PL-SQL REPLACE function

Examples:

SELECT REPLACE(url, 'localhost:1001','localhost') AS Test
FROM cmn_pt_site_map
WHERE url LIKE '%localhost:1001%'

UPDATE cmn_pt_site_map
SET url = REPLACE(url, 'localhost:1001','localhost')
WHERE url LIKE '%localhost:1001%'