Regular Expression confusion 2005-04-20 - By Jared Still
Hi Bill,
Have you tried using dump() on the row?
It is possible that the '-' is not quite what you think it is.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On 4/20/05, William B Ferguson <wbfergus@(protected)> wrote:
>
>
> SQL> set escape off
> SQL> select UPPER(regexp_replace(name,'[''''|"|;| |-|,|.]')) test_data
> 2 from names
> 3 where upper(regexp_replace(name,'[[:punct:][:space:]]'))
> 4 like ('%JGO%');
>
> TEST_DATA
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
> A-JGOLDMININGCO
>
--
http://www.freelists.org/webpage/oracle-l
|
|
