Link to home
Start Free TrialLog in
Avatar of gswitz
gswitz

asked on

Oracle RegExp to find a row with a special character...

Hello,

I have a problem with an application that appears to be data driven. It looks like there must be a special character in a field in the query for the application that is causing an error in the application.

Can someone help me write a regular expression query to find all rows that include special characters?

Something like...

Select * from
(select upper(chr(300))||'0' a from dual)
where regexp_like(a,'[^a-zA-Z0-9\-\@\<\>]');

I'm not really sure what I'm looking for. I'm hunting for a goofy character that's breaking the app.
SOLUTION
Avatar of Alex [***Alex140181***]
Alex [***Alex140181***]
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gswitz
gswitz

ASKER

Thanks!!