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: how to split strings in pl/sql or in sql/plus

Re: how to split strings in pl/sql or in sql/plus

From: Chris ( Val ) <chrisval_at_bigpond.com.au>
Date: 6 Jun 2005 17:42:45 -0700
Message-ID: <1118104965.614715.56390@z14g2000cwz.googlegroups.com>

baka wrote:
> hello
> I want to break the the follwoing string variable into two strings.
>
> eg; str="abcd\wxyz"
> into
> str1="abcd"
> str2="wxyz"
>
> i know how to do this in all 4GLs .
> is it possible to do it in SQL/PLUS or PL/SQL?
> (by the way i am re3ading a datfile from a .csv)

Oracle provides some built in functions for you to handle this sort of thing.

Look uo the following functions:

  1. INSTR(...
  2. SUBSTR(...
Cheers,
Chris Val Received on Mon Jun 06 2005 - 19:42:45 CDT

Original text of this message

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