Re: regexp_substr occurrences problem

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. Received on Tue Sep 19 2006 - 05:40:56 CDT