Dear People,
I want to trace out the names where a character occured more than once.for ex, i need o/p as
ENAME
ALLEN
TURNER
ADAMS
...
In which all the above name consists of repeated characters.
I use Oracle 10g and i tried using REGEXP say for ex,
SELECT ENAME FROM EMP WHERE REGEXP_LIKE(ENAME,'L{2}');
ENAME
----------
ALLEN
MILLER
but this works only for single character.how to specify condition for any character?.pls suggest me.
With Regards
VIDS