Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Retrieve data from a varchar2(4000) based on a delimiter.

Retrieve data from a varchar2(4000) based on a delimiter.

From: Dermot Mackey <dmackey_at_iel.ie>
Date: Wed, 01 Aug 2001 15:29:43 +0100
Message-ID: <3B681257.6356A9FC@iel.ie> 






Hi guys,



I have a string of 4000 characters which contains data from 20 fields
seperated by a delimiter. Is there any method in PLSQL that will allow
me to search this string for the delimiter and therefore allowing me to
seperate and extract the data in the string into individual variables ?



Many Thanks,


Dermot
Received on Wed Aug 01 2001 - 09:29:43 CDT












Original text of this message













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