REGEXP_REPLACE doesn't comply with the standard, does it ?

The following works *everywhere* I've ran it: $ echo rbcde_fghijkl_mnopq|sed "s/_\([a-z]\)/\u\1/g" rbcdeFghijklMnopq

(in vi, at several Unix prompts...: I want to replace letters that come after an underscore by their uppercase value, and get rid of this underscore)

I've found no way to have the same behaviour using REGEXP_REPLACE: SQL> select regexp_replace('rbcde_fghijkl_mnopq','_\([a-z]\)','\u\1') from dual;
REGEXP_REPLACE('RBC

How can you then obtain in SQL what I'm getting above in Ux ?

Thanks.
Spendius Received on Tue Jun 29 2010 - 07:06:45 CDT