Graeme, Very interesting! Is there a way to get this on http://www.orafaq.com? Larry -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Graeme Farmer Sent: Monday, June 14, 2004 6:59 PM To: 'oracle-l@xxxxxxxxxxxxx' Subject: RE: SQL Language Quick Reference 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. All that's required is Install Oracle Text schema CREATE DIRECTORY orapdf AS '<path to docs>'; BEGIN ctx_ddl.create_preference('ORAPDF','FILE_DATASTORE'); ctx_ddl.set_attribute('ORAPDF','PATH',''); END; / drop table orapdf; create table orapdf (docid number, pdf varchar2(255)); insert into orapdf values (1,'/docs/oracle/9.2.1/concepts.pdf'); insert into orapdf values (2,'/docs/oracle/9.2.1/admin_guide.pdf'); insert into orapdf values (3,'/docs/oracle/9.2.1/admin_guide_unix.pdf'); insert into orapdf values (4,'/docs/oracle/9.2.1/admin_guide_win32.pdf'); ... ... commit; create index orapdf_idx01 on orapdf (pdf) indextype is ctxsys.context parameters ('datastore ctxsys.file_datastore filter ctxsys.inso_filter') / and then a simple query like: column document format a100 column version format a12 select score(1) rank, substr(pdf,instr(pdf,'/',1,3)+1,instr(pdf,'/',1,4)-instr(pdf,'/',1,3)-1) version, 'acroread' reader, pdf document from gfarmer.orapdf where contains(pdf,'&&1',1) > 0 order by score(1) desc / output is like: sys@gfprd> @orasrch 'pctfree' RANK VERSION READER DOCUMENT ---------- ------------ -------- ---------------------------------------------------------------------------- ------------------------ 100 9.2.0 acroread /docs/oracle/9.2.0/olap_users_guide.pdf 100 9.2.0 acroread /docs/oracle/9.2.0/error_messages.pdf 100 9.2.0 acroread /docs/oracle/9.2.0/concepts.pdf ... ... Elapsed: 00:00:00.01 Then I cut and paste the reader and document and then perform a search in the document. Adding new docs is as simple as an insert into the tables and resync of the index: BEGIN ctx_ddl.sync_index('GFARMER.ORAPDF_IDX01'); END; / Indexing is very CPU intensive and can take some time, but it pays off pretty quickly!! Cheers, Graeme. -----Original Message----- From: Michael Thomas [mailto:mhthomas@xxxxxxxxx] Sent: Tuesday, 15 June 2004 1:59 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: SQL Language Quick Reference Hi, I've found a combination that makes reading docs (e.g. pdf) a pleasure on my laptop. 1) Get a laptop with at least a 15in diagonal screen and resolution of 1280x800. The screen quality makes a big difference. 2) Use Acrobat where you can use the "Note Tool" to save comments in the pdf files. With the navigation panel on the left, you can tab to "comments" and flip back and forth between different notes just like book tabs. 3) Pdf also provides the option to search, one document at at time, while "off-line" from the internet. I wish I knew a way to do "off-line" search the Oracle html documentation like you can at: http://otn.oracle.com/pls/db92/db92.homepage But, my laptop is not a very powerful html (nor pdf) search engine. :-) When I know what I'm searching for and select the correct pdf, then its better than flipping pages. But, if I'm generally lost then the html search of Oracle documentation is the fastest way to get good doc details for a specific Oracle version. HTH. Regards, Mike Thomas --- Rachel Carmichael <wisernet100@xxxxxxxxx> wrote: > Dennis, > > WAAAY too much work! > > I've never been a fan of online documentation -- > it's just not > portable. and I can't hold my finger on one page, > flip back to another > to verify things. > > There are too many manuals these days, with way too > many pages in them. > > Rachel > > > --- DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx> wrote: > > Rachel - I find the pdf documents are great for > that purpose. Print > > 'em off, __________________________________ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ********************************************************************** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------