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!

How to write a query to return rows having varchar column containing even a single occurrence of spe

user13708515Aug 4 2014 — edited Aug 5 2014

How to write a query to return rows having varchar column containing even a single occurrence of special characters like Ÿ and ¿

I have a table having columns with values like

MINNEAŸPOLIS and THAN ¿VV ¿A

Only allowable chars in this column are alphabets, numerics, spaces, dots and brackets.

Please help write a SELECT SQL query using Regexp_like or any other option.
This post has been answered by user13708515 on Aug 5 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 2 2014
Added on Aug 4 2014
#database, #query, #sql
11 comments
3,561 views