Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need to find special characters using regexp

user13115886Jul 19 2016 — edited Jul 19 2016

Hi,

using regexp, I need to find the data where in the data contains any special characters, other than A-Z, 0-9 and all symbols on the keyboard,

For example: VOL Spó?ka z ograniczon? odpowiedzialno?ci? Spó?ka Komandytowa

Special Character: ó

Will need to find this data using regexp.

I tried REGEXP_LIKE (str, '[^ -~]', 'i'), but I am getting other vaues as well.

Thanks

Aman
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 16 2016
Added on Jul 19 2016
4 comments
1,492 views