RE: SQL Language Quick Reference

From: Graeme Farmer <graeme.farmer_at_mincom.com>
Date: Thu, 17 Jun 2004 21:43:20 +1000
Message-ID: <DA5B390A2CBAA64AB2367C2EDA3210F60CA656CA@tqxbneclu03.root.tequinox.com>

nope! not as far as I know. context indexes can be created on many different document types which have no concept of page numbers (eg html, text files, etc) so it would probably be inappropriate to record page numbers against matched tokens for say pdfs and msword docs only.

you can have the results processed into token highlighted html result pages but I've never bothered, involves some webification which i've never spent the time getting involved in.

i'm happy enough with my "partition pruning" method of finding what i'm looking for!!

cheers,
Graeme.

-----Original Message-----
From: Michael Thomas [mailto:mhthomas_at_yahoo.com] Sent: Thursday, 17 June 2004 5:54 AM
To: oracle-l_at_freelists.org
Subject: RE: SQL Language Quick Reference

Hi Graeme,

Thanks for the info.

Here is another question along the same lines for anyone on the list.

Q: Is it possible to modify your technique to also identify all matching *pages* in the pdf file?

(where *pages* are pages numbers as in 'go-to-page', not document labels like VII or 1-23)

A new feature (/A switch) in version 6.0 allows acrobat or acrord32 to open to a specific page number.

E.g.:
AcroRd32 /A page=122 /N /S
J:\tempMy\database\otnweb2\docs\apps11i\clinical\B10330_01.pdf

Your suggested technique may become my new favorite method for reading Oracle documents. Also, Acrobat Reader version 6.0.1, has unbelievably better search capabilities. E.g. a search tool bar that hyperlinks to *all* resulting matches.

Graeme, thanks again for your tip.

Regards,

Mike Thomas

• Graeme Farmer <graeme.farmer_at_mincom.com> wrote:
  > Something that grew out of a desire to play with
  > Oracle Text, I created
  > context indexes in Oracle which have indexed all the
  > Oracle 8i, 9i, 10g pdfs
  > and a host of whitepapers as well and searching
  > across all Oracle
  > documentation is as simple as running a basic
  > query!! The results are
  > returned immediately and ranked according to the
  > number of references found.
  >
  > Very helpful when you know what you're looking for
  > but not sure which doc
  > it's in.
  >
  

  ---

Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


-- 
This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please notify the sender and delete the transmission. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Limited unless expressly stated otherwise.

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jun 17 2004 - 06:40:54 CDT