RE: SQL Language Quick Reference
- From: Wolfson Larry - lwolfs <lawrence.wolfson@xxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 12 Jul 2004 16:37:49 -0500
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
-----------------------------------------------------------------
Other related posts:
