SQL error ORA-00920: invalid relational operator, and I don't know why
<p>I'm going to use regex_count and regex_like in one statement, but first I need to get count to work.  I don't understand why it is growing an error when these are valid columns, correct amount of parenthesis and I have the apostrophes.  Also using Oracle SQL Developer.</p>

<pre><code>select employee_name, LTRIM(street)
from employee
where 
regexp_count( street, '[[:digit:]]' );
</code></pre>

<p>ORA-00920: invalid relational operator
00920. 00000 -  "invalid relational operator"
*Cause:<br>
*Action:
Error at Line: 4 Column: 37</p>

<p>What I'm really trying to do is remove any starting street numbers from the street and return the result set.  I was going to use this below, and then figure out how to feed it into a substring function to get the result set i'm looking for.  Any suggestions?</p>

<pre><code>select employee_name, LTRIM(street)
from employee
where 
regexp_like ( street, '[[:digit:]]', 1, regexp_count( street, '[[:digit:]]' ) );
</code></pre>