Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Text search on a BLOB

555369Aug 28 2008 — edited Aug 28 2008
Hi,

I'm using Oracle 9i. I've textual data stored as BLOB in one of the columns in my table and my table has nearly 30 million records. I want to perform a text search on the data stored as BLOB. As the number of records is huge, it is not feasible to extract the BLOB row by row and conduct a search. Kindly let me know how I could conduct the search on the BLOB data using SQL.

Thanks,
Babu

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 25 2008
Added on Aug 28 2008
#blob, #search, #sql
3 comments
638 views