Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sql string massaging

Re: sql string massaging

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 05 Sep 2006 04:43:03 -0700
Message-ID: <1157456583.841497@bubbleator.drizzle.com>


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 Group
Received on Tue Sep 05 2006 - 06:43:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US