Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: sql string massaging
soalvajavab1_at_yahoo.com wrote:
> we have bunch of tables which has cutomer names in one column, now we
> need to separate them as firstname, middlename and lastname and then
> transfer them to new target table. can you please give me the string
> conversion command/procedure which can do that..many thanks
Morgan's Library at www.psoug.org
Click on REGULAR EXPRESSIONS and SUBSTRING FUNCTION
-- Puget Sound Oracle Users GroupReceived on Tue Sep 05 2006 - 06:43:03 CDT
![]() |
![]() |