Conversion national characters to ASCII with out spaces in Oracle 11g+

SELECT REPLACE (REPLACE (CONVERT (LOCATION_CITY_PL, 'US7ASCII'), ' ', ''), '-', '') 
FROM CITIES;

 

Hits: 9