Re: Select data prior to a character in a row?
From: DP <dxpesse_at_gmail.com>
Date: Thu, 3 Jan 2008 11:51:58 -0800 (PST)
Message-ID: <43d2b8dd-fd57-494e-bdc1-4bbb5082d313@d4g2000prg.googlegroups.com>
Date: Thu, 3 Jan 2008 11:51:58 -0800 (PST)
Message-ID: <43d2b8dd-fd57-494e-bdc1-4bbb5082d313@d4g2000prg.googlegroups.com>
On Jan 3, 12:45 pm, Jerome Vitalis
<vitalismanN0S..._at_gmail.com.invalid> wrote:
> DP wrote:
> > What I can't figure out is how to select data up to or before the
> > first open paran.
>
> > I have tried RTIRM with no luck.
>
> > Any Help you can give me would be greatly appreciated.
>
> Oracle version ?
> reg_exp might be an option.
Sorry about that ...
Version 9.2.0.6
I wish it was 10g, then reg_exp would be usable.
Thanks Received on Thu Jan 03 2008 - 13:51:58 CST