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: Thomas Kellerer <ESPKLFCTEKVY_at_spammotel.com>
Date: Tue, 05 Sep 2006 08:41:12 +0200
Message-ID: <4m4kg8F4dghrU2@individual.net>

On 05.09.2006 08:35 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
>

substr()

See:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/functions119a.htm#87068

-- 
It's not a RootKit - it's a Sony
Received on Tue Sep 05 2006 - 01:41:12 CDT

Original text of this message

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