Extracting Substrings from LONG datatype

Surely someone knows how to do this:

I have string data encoded into a LONG datatype field in Oracle 8. I am confident that I know what substrings begin and end the substrings that I must extract, and they may include single quote characters. Each of the substrings is likely (but not necessarily) less that 4K characters long. The usual substring extraction functions do not work on a LONG datatype.

How can I extract the substrings from the LONG datatype within a "select" query?

Many thanks,

Allen Brown

Received on Wed Sep 01 1999 - 17:25:09 CDT