Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to search for pattern on LONG columns
The only luck I've had with searching long columns is to use a PR0*C program to read the data into a VARCHAR host variable. Just make the VARCHAR array size long enough to hold the most data which will ever be in the column.
Then, you can use C to search or manipulate the string any way you like.
Sandy Received on Thu Jan 15 1998 - 00:00:00 CST