Re: Text searching within multiple rows

Hi John,

You are maybe interested in Intermedia Text (8i) or Oracle Text (9i) where you can build one index over multiple columns and search with

select col
from table
where contains(index,'token')>0;

Thomas

John wrote:
> Hi,
>
> I have a database that contains units of code, broken into chunks of text
> across multiple rows with a counter to stitch them back together.
>
> I have a requirement to perform regular expression searches on the text. I
> would prefer to use Oracle's built in regular expression matching wildcards,
> but would like them to extend across the chunk boundaries.
>
> So, given a table containing
>
> PROG_ID CHUNK_NUM CHUNK
> -------------------------------------------------
>
> and a search within the CHUNKs for a specific PROG_ID, is there any SQL that
> could perform this, or should I look to PL/SQL or perhaps a view that does
> the stitching of the blocks?
>
> thanks,
>
> John.
>
>
Received on Thu Dec 05 2002 - 14:53:04 CST