-----Original Message-----
From: I-Lin Kuo [mailto:[EMAIL PROTECTED]
Sent: Fri 14/11/2003 19:07
To: CF-Talk
Cc:
Subject: Re: Oracle CLOBS SQL
Thanks for alerting me to this. According to
documentation, it's a new feature in 10g. Two words of
warning on searching CLOBs:
- CLOBs aren't made to be searched or manipulated or
concatenated, but Oracle usually converts a CLOB to a
string to allow this.
- the CLOB-string conversion usually only takes the
first 4000 bytes.
--- Deanna Schneider <[EMAIL PROTECTED]>
wrote:
> Here's a quick tutorial on regular expressions in
> Oracle, but I'm not sure
> when they became supported (I don't think they're
> available in 8i):
>
> http://otn.oracle.com/books/pdfs/gennick_ch01.pdf
>
>
> ----- Original Message -----
> From: "Jochem van Dieten" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, November 14, 2003 11:44 AM
> Subject: Re: Oracle CLOBS SQL
>
>
> > [EMAIL PROTECTED] wrote:
> > >
> > > The clobs contain be free text with no HTML
> allowed. The links that may
> > > be in the clob will just be plain text and may
> not actually contain
> > > http://.
> > >
> > > It might just be www.domain.com or even
> domain.com, that's why I was
> > > thinking that I would need regexp, but was
> wondering aloud whether SQL
> > > could do something like that
> >
> > SQL doesn't do normal regex. But there is a
> functionality in SQL
> > that combines parts from LIKE and regex, named
> SIMILAR TO. You
> > might want to check the Oracle docs to see if it
> is supported.
> > The pattern would look something like:
> >
> > SELECT *
> > FROM table
> > WHERE whatever SIMILAR TO
> > '%[abcdefghijklmnopqrstuvwxyz]+.(com|org|net)%'
> >
> > Jochem
> >
> >
> > --
> > Who needs virtual reality
> > if you can just dream?
> > - Loesje
> >
> >
> >
>
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
