Text searching within multiple rows

From: John <junk_at_junk.com>
Date: Thu, 5 Dec 2002 17:16:10 +1100
Message-ID: <asmqr7$hjr$1@perki.connect.com.au>

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 - 00:16:10 CST