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]
