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

Home -> Community -> Usenet -> c.d.o.misc -> how to seperate a string on a certain position of a character (e.g:semikolon) in PLSQL

how to seperate a string on a certain position of a character (e.g:semikolon) in PLSQL

From: Filiz Duman <none_at_aol.com>
Date: Thu, 3 Apr 2003 16:33:49 +0100
Message-ID: <b6hkni$lr4$1@pheidippides.axion.bt.co.uk> 





I have a string e.g:



cc_people := 'adam.white_at_xxx.com;andrew.guest_at_xxx.com;jim.whatever_at_yyy.com'


.....




how can I get each individualls email address out of here e.g



adam.while_at_xxx.com


andrew.guest_at_xxx.com


jim.whatever_at_yyy.com


.

.

.



Any ideas how/which string operations to use ?
Thanks in advance.
Received on Thu Apr 03 2003 - 09:33:49 CST












Original text of this message













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