Solved

Oracle Regular Expression

Posted on 2010-09-21
4
851 Views
Last Modified: 2013-12-07
I need to select, from an Oracle table, only the rows in which the column GOOFY contains AT LEAST one character different from:
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789
and space

How can I achieve this?
0
Comment
Question by:hc2342uhxx3vw36x96hq
  • 2
4 Comments
 
LVL 17

Expert Comment

by:Shinesh Premrajan
ID: 33724401
select * from tablename where regexp_like (goofy, '[0-9a-z]+','i');

Hope this helps
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 33724457
try these

regexp_like(goofy,'[^abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789 ]');

or

regexp_like(goofy,'[^a-zA-Z0-9 ]')
0
 
LVL 73

Accepted Solution

by:
sdstuber earned 500 total points
ID: 33724535
shinuq,  

your expression will find strings that have at least one digit or letter.

the question asks to find strings with something OTHER than those characters or a space.
0
 
LVL 1

Author Closing Comment

by:hc2342uhxx3vw36x96hq
ID: 33733275
Thank you very much for your kind cooperation!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now