SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Split String in Array

muttleychessNov 23 2006 — edited Nov 23 2006

Hi

I need Split a String to array (table) and return 4 Codes and 4 Description

The format of string is:

Code1 || chr(32)|| Descption01||chr(32)||Code2 || chr(32)|| Descption02||chr(32)||Code3 || chr(32)|| Descption03||chr(32)||Code4 || chr(32)|| Descption04||chr(32)

But There is Code without description

How can I return it to Array

all Help will be good !!!
PS -- I Can put all Code Possible in type or other place (not table)
Ah, Description can to have blank spaces , example:
cod1=COD1
DESCRIPTION01= 'THIS COD1'
'COD1 THIS COD1 COD2 DESCRPT2'

Message was edited by:
muttleychess

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 21 2006

Added on Nov 23 2006

5 comments

3,949 views