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!

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
722 views