Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to split strings in pl/sql or in sql/plus
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:
![]() |
![]() |