<div>
select * from tablename where regexp_like (goofy, '[0-9a-z]+','i');<br />
<br />
Hope this helps
</div>


select * from tablename where regexp_like (goofy, '[0-9a-z]+','i');

Hope this helps

<div>
try these<br />
<br />
regexp_like(goofy,'[^abcde<wbr />fghijklmno<wbr />pqrstuvwxy<wbr />zABCDEFGHI<wbr />JKLMNOPQRS<wbr />TUVWXYZ012<wbr />3456789 ]');<br />
<br />
or <br />
<br />
regexp_like(goofy,'[^a-zA-<wbr />Z0-9 ]')
</div>


try these

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

or

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

<div>
Thank you very much for your kind cooperation!
</div>


Thank you very much for your kind cooperation!

<div>
<div class="content wysiwyg-content">
I need to select, from an Oracle table, only the rows in which the column GOOFY contains AT LEAST one character different from:<br />
abcdefghijklmnopqrstuvwxyz<wbr />ABCDEFGHIJ<wbr />KLMNOPQRST<wbr />UVWXYZ0123<wbr />456789<br />
and space<br />
<br />
How can I achieve this?
</div>
</div>


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?

Oracle Regular Expression

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.