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;    

Conversion national characters to ASCII with out spaces in Oracle 11g+ SELECT REPLACE (REPLACE (CONVERT (LOCATION_CITY_PL, 'US7ASCII'), ' ', ''), '-', '') FROM CITIES;    

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

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

 

 

December 11th, 2017sql 0 comments on SQL Conversion national characters to ASCII without spaces29,

Related Posts

Verify type parameters call in Oracle procedure

Alternative Quoting Mechanism (”Q”) for String Literals
Gallery

Alternative Quoting Mechanism (”Q”) for String Literals

3d-inventory-oracle-api
Gallery

3d-inventory-oracle-api

SQL partition by date keeping weekly and sub partition
Gallery

SQL partition by date keeping weekly and sub partition

Materialized Views: REFRESH FAST Categories
Gallery

Materialized Views: REFRESH FAST Categories

Subscribe
Notify of
guest
0 Comments
Newest
Oldest Most Voted
Inline Feedbacks
View all comments