<div>
select * from yourtable<br />
where regexp_like(yourstring,'[^<wbr />-]-[^-] ')<br />
<br />
this will find any dash surrounded by non-dashes
</div>


select * from yourtable
where regexp_like(yourstring,'[^-]-[^-] ')

this will find any dash surrounded by non-dashes

<div>
Thank you, now that I see it, it is much clearer and obvious!!!!
</div>


Thank you, now that I see it, it is much clearer and obvious!!!!

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I am looking for a regexp in Oracle sql to find the following conditions.<br />
<br />
(char)-(space)<br />
or<br />
(space)-(char)<br />
<br />
The middle character is a - (dash). Basically I want any rows that have a dash with a character, including space, next to the dash on either side.<br />
<br />
Thank you,<br />
<br />
Bob
</div>
</div>


Hello,

I am looking for a regexp in Oracle sql to find the following conditions.

(char)-(space)
or
(space)-(char)

The middle character is a - (dash). Basically I want any rows that have a dash with a character, including space, next to the dash on either side.

Thank you,

Bob

Oracle RegExp to Find String

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.