Skip to Main Content

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!

regular expression for replace

matAug 7 2007 — edited Aug 8 2007
I have the following sample values in a table column ( first name, middle initial, last name)

Assemblymember Von K. Wright
Assemblyman Kalvin J. Rowling
Assemblywoman Debby J. Sanders

How can I write a regular expression where I can extract the above values as follows
Wright V
Rowling K
Sander D

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 5 2007
Added on Aug 7 2007
4 comments
220 views