Re: regexp_substr occurrences problem

PhilHibbs schrieb:
> So what should I write to get DEF and GHI out of 'ABC|DEF|GHI|JKL',
> assuming variable length and number of segments, e.g.
> 'A|BC|DEF|GHIJ|KLMNO' should match 'BC', 'DEF', and 'GHIJ'?
>
> Phil Hibbs.
>

Not knowing much about your restrictions, for the case you requested simple '\|.+\|' will suffice.

Best regards

Maxim Received on Tue Sep 19 2006 - 09:13:14 CDT