Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!z14g2000cwz.googlegroups.com!not-for-mail
From: "Chris ( Val )" <chrisval@bigpond.com.au>
Newsgroups: comp.databases.oracle.server
Subject: Re: how to split strings in pl/sql or in sql/plus
Date: 6 Jun 2005 17:42:45 -0700
Organization: http://groups.google.com
Lines: 26
Message-ID: <1118104965.614715.56390@z14g2000cwz.googlegroups.com>
References: <1118104516.241609.275800@g43g2000cwa.googlegroups.com>
NNTP-Posting-Host: 203.89.239.218
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1118104971 682 127.0.0.1 (7 Jun 2005 00:42:51 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 7 Jun 2005 00:42:51 +0000 (UTC)
In-Reply-To: <1118104516.241609.275800@g43g2000cwa.googlegroups.com>
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: z14g2000cwz.googlegroups.com; posting-host=203.89.239.218;
   posting-account=NN6ARQwAAACSjczBRtLvdcoDYZmZzbx0
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:244401



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