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