PL/SQL (MOSC)

MOSC Banner

query for special characters like single quote in a column

edited Dec 17, 2015 10:14AM in PL/SQL (MOSC) 4 commentsAnswered


I have regular expressions like ', % ,-  and space which I need pull in query . I'm able to pull all but ' and space are not being pulled.


Below is the query used and sample data


select *from address_table

where regexp_like(city,'[^]^A-Z^a-z^0-9^[^.^{^}^ ^,^(^)^-^%^/^\^]' );


XXX

--------------------

xxx'ksjd

yyy'asdf

abc def

abc-def

ab-cd-ef

ab--cc-dd--ee

sa'na mnre.

Thanks,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center