Non Ascii data Oracle
-- Oracle Query to identify non ascii data SELECT 'PRICING' , 'PROD_CHAN' , 'PROD_CHAN_TYP_NM' , PROD_CHAN_TYP_NM FROM PRICING . PROD_CHAN WHERE LENGTH ( ASCIISTR ( PROD_CHAN_TYP_NM )) <> LENGTH ( PROD_CHAN_TYP_NM ) ; -- Oracle Query to identify non ascii data SELECT 'PRICING' , 'PROD_CHAN' , 'PROD_CHAN_TYP_NM' , PROD_CHAN_TYP_NM FROM PRICING . PROD_CHAN WHERE REPLACE ( TRANSLATE ( LOWER ( PROD_CHAN_TYP_NM ) , 'abcdefghijklmnopqrstuvwxyz1234567890_-+=() *&^%$#@!~`:}{][|\/?.,><"'''||chr ( 10 )|| chr ( 13 )|| chr ( 9 ), 'X' ), 'X' , '' ) ;