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

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

From: baka <mesundara_at_hotmail.com>
Date: 6 Jun 2005 17:35:16 -0700
Message-ID: <1118104516.241609.275800@g43g2000cwa.googlegroups.com> 






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)



Thanks in Advance
Received on Mon Jun 06 2005 - 19:35:16 CDT












Original text of this message













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