SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

String manipulation

295545Jun 27 2005 — edited Jul 1 2005

Hi there

i have web page with free format field for email address of the person.User is allowed to enter as many email addresses as he wants. I need to separate them by ;
and also to replace all other possible separators (like '' , or ,) with ;.

simple replace (str,'',';') doesn't work as email might be aaa@xyz.com bbb@xyz.com
or
aaa@xyz.com, bbb@xyz.com(there are spaces after ,)

Any idea how to acomplish this in pl/sql?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 29 2005

Added on Jun 27 2005

11 comments

391 views