SQL Conversion national characters to ASCII without spaces

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

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

 

Proudly powered by WordPress | Theme: Baskerville 2 by Anders Noren.

Up ↑