RE: SQL Language Quick Reference
- From: Michael Thomas <mhthomas@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 12 Jul 2004 19:40:44 -0700 (PDT)
Hi,
FYI. I've done some followup research to build a
search tool for this function. At this point here is
some additional news. You can add some basic
functionality to Graeme's suggestion, immediately.
You need Acrobat/Reader 6.0.x or above to perform
*cool searches*. Unfortunately, all xNIX flavors are
still on verion 5.x, so *cool searches* are limited to
the windows platform right now.
The *cool searches* are defined as:
You can pass _ONE_ command line search term to
acrobat/reader when opening the file and you will get
a very nice hit list for that term in a side panel.
The syntax is:
Acrord32 /A search=Oracle C:\clinical\B10330_01.pdf
The command line technique is limited to _ONE_search
term with no white space (yes I tried to find
workaround, :-( ). But, since its windows there are
more acrobat/reader API's and techniques to do *even
cooler searches*.
The *even cooler searches* require more programming
work. These are defined as multi-word, AND/OR/etc,
match case, etc types just like Tahiti. More on this
later, as promised.
That's all. Great idea Graeme!
Regards,
Mike Thomas
--- Wolfson Larry - lwolfs
<lawrence.wolfson@xxxxxxxxxx> wrote:
> 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
>
----------------------------------------------------------------
>
=== message truncated ===
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
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@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
-----------------------------------------------------------------
Other related posts:
