From oracle-l-bounce@freelists.org Mon Jun 14 18:55:31 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5ENtFu25481 for ; Mon, 14 Jun 2004 18:55:25 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i5ENt5625470 for ; Mon, 14 Jun 2004 18:55:15 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 707E372D2B3; Mon, 14 Jun 2004 18:39:54 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13407-58; Mon, 14 Jun 2004 18:39:54 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B2E7172D247; Mon, 14 Jun 2004 18:39:53 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 14 Jun 2004 18:38:31 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8247372C483 for ; Mon, 14 Jun 2004 18:38:30 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13339-36 for ; Mon, 14 Jun 2004 18:38:30 -0500 (EST) Received: from blockhead.mincom.com (blockhead1.mincom.com [203.202.173.251]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 18A3272C0C0 for ; Mon, 14 Jun 2004 18:38:29 -0500 (EST) Received: (from uucp@localhost) by blockhead.mincom.com (8.9.3/8.9.3) id JAA76788 for ; Tue, 15 Jun 2004 09:58:40 +1000 (EST) (envelope-from graeme.farmer@mincom.com) Received: from bnepms01.mincom.oz.au(172.17.65.84) via SMTP by blockhead.mincom.oz.au, id smtpdo76781; Tue Jun 15 09:58:36 2004 Received: from TQXBNECLU03.root.tequinox.com (unverified [172.31.4.22]) by bnepms01.mincom.oz.au (Content Technologies SMTPRS 4.3.12) with ESMTP id for ; Tue, 15 Jun 2004 09:58:36 +1000 Received: by tqxbneclu03.root.tequinox.com with Internet Mail Service (5.5.2657.72) id ; Tue, 15 Jun 2004 09:58:35 +1000 Message-ID: From: Graeme Farmer To: "'oracle-l@freelists.org'" Subject: RE: SQL Language Quick Reference Date: Tue, 15 Jun 2004 09:58:31 +1000 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: text/plain; charset="iso-8859-1" X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2719 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: graeme.farmer@mincom.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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 ''; 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@yahoo.com] Sent: Tuesday, 15 June 2004 1:59 AM To: oracle-l@freelists.org 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 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 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@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@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 -----------------------------------------------------------------