Skip to Main Content

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 query a column to see if it contains any special characters?

793174Sep 21 2010 — edited Sep 21 2010
What is the best way to find out if a column has any special characters in it?

Is there a special Oracle function to detect special characters?

Also, are these the only Oracle special characters?
,
&
=
?
{ }
\
( )
[ ]
-
;
~
|
$
!
>
*
%
_
This post has been answered by pollywog on Sep 21 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 19 2010
Added on Sep 21 2010
3 comments
3,589 views