CODEWITHSUNDEEP
sqloracle-databaseplsql
Raghavan
Raghavan

Reputation: 401

Getting the Column containing the non-english language in ORACLE

enter image description here

I have above entries in my database, my requirement is to extract the fields containing the non-english language characters ( including if the data containing the combination of english and non-english characters like HotelName field for the ID 45).

I tried by regexp_like function by looking for the alphanumeric and non-alphanumeric, but i have some data with combination of both the condition fails there.

Thanks in Advance

Raghavan

Upvotes: 1

Views: 886

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1270713

Does this do what you want?

where regexp_like(hotelname, '[^a-zA-Z0-9 ]')

That is, where the hotel name contains any character that is not a "letter" or digit. You may need to take additional characters into account as well, such as commas, periods, and hyphens.

Upvotes: 1

Related Questions