Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!newspeer1.nwr.nac.net!solnet.ch!solnet.ch!fu-berlin.de!newsfeed.iinet.net.au!newsfeed.iinet.net.au!news.iinet.net.au!not-for-mail Message-ID: <3EE0730D.60EE@yahoo.com> Date: Fri, 06 Jun 2003 18:55:09 +0800 From: Connor McDonald X-Mailer: Mozilla 3.01 (WinNT; I) MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: Searching in a BLOB Field References: <5bd061a8.0306060149.1961ad60@posting.google.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 23 NNTP-Posting-Host: i173-027.nv.iinet.net.au X-Trace: news.iinet.net.au 1054896965 27129 203.59.173.27 Xref: core-easynews comp.databases.oracle.server:188857 X-Received-Date: Fri, 06 Jun 2003 03:59:22 MST (news.easynews.com) Yavuz Bogazci wrote: > > Hi, > > i have a BLOB Field in wich i store my MS Word an MS Excel Documents. > My Problem is now, that i don't know how to search a textpart in my > document in this BLOB Field. I don't know if this is the right group > but i don't know where to begin. > > thanks > yavuz bogazci You would probably need to index it with Oracle Text (if the filters support it) and then use the "contains" clause hth connor -- ========================= Connor McDonald http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue"