Manipulating a string

From: <kamlesh.kumar_at_churchill.co.uk>
Date: Fri, 21 Jan 2000 18:24:51 GMT
Message-ID: <86a88v$cmb$1@nnrp1.deja.com>

Hi All ,

I have some problem in manipulating a string The string like this :-

0000017+NPE:00:PRO:01:A00802+
+17012000:163000+16012001:235959+1N111++B00018

The field delimiters are + : ;

I wants to put all data in diffident fields like this field1 := 00000017 , field2 := NPE ........etc . It should be dynamic caz i have lot of string different string like this .

In PL/SQL not in SQL/Loader .

Thanks
Kamalesh Kumar

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jan 21 2000 - 12:24:51 CST