Oracle Text Reference Release 9.0.1 Part Number A90121-01 |
|
This manual provides reference information for Oracle Text. Use it as a reference for creating Oracle Text indexes, for issuing Oracle Text queries, for presenting documents, and for using the Oracle Text PL/SQL packages.
This preface contains these topics:
Oracle Text Reference is intended for an Oracle Text application developer or a system administrator responsible for maintaining the Oracle Text system.
To use this document, you need experience with the Oracle relational database management system, SQL, SQL*Plus, and PL/SQL. See the documentation provided with your hardware and software for additional information.
If you are unfamiliar with the Oracle RDBMS and related tools, read Chapter 1, "An Introduction to the Oracle Server", in Oracle9i Concepts. The chapter is a comprehensive introduction to the concepts and terminology used throughout Oracle documentation.
This document contains:
This chapter describes the SQL statements and operators you can use with Oracle Text.
This chapter describes the indexing types you can use to create an Oracle Text index.
This chapter describes the operators you can use in CONTAINS queries.
This chapter describes the special characters you can use in CONTAINS queries.
This chapter describes the procedures in the CTX_ADM PL/SQL package.
This chapter describes the procedures in the CTX_DDL PL/SQL package. Use this package for maintaining your index.
This chapter describes the procedures in the CTX_DOC PL/SQL package. Use this package for document services such as document presentation.
This chapter describes the procedures in the CTX_OUTPUT PL/SQL package. Use this package to manage your index error log files.
This chapter describes the procedures in the CTX_QUERY PL/SQL package. Use this package to manage queries such as to count hits and to generate query explain plan information.
This chapter describes the procedures in the CTX_THES PL/SQL package. Use this package to manage your thesaurus.
This chapter describes the supplied executables for Oracle Text including ctxload, the thesaurus loading program, and ctxkbtc, the knowledge base compiler.
This appendix describes the result tables for some of the procedures in CTX_DOC, CTX_QUERY, and CTX_THES packages.
This appendix describes the supported document formats that can be filtered with the Inso filter for indexing.
This appendix provides some basic examples for populating a text table.
This appendix describes the supplied stoplist for each supported language.
This appendix describes the alternate spelling conventions used for German, Danish, and Swedish.
This appendix describes the scoring algorithm used for word queries.
This appendix describes the Oracle Text views.
This appendix describes stopword transformations.
This appendix describes the supplied English Knowledge Base.
For more information, see these Oracle resources:
For more information about Oracle Text, see:
For more information about Oracle9i, see:
For more information about PL/SQL, see:
In North America, printed documentation is available for sale in the Oracle Store at
http://oraclestore.oracle.com/
Customers in Europe, the Middle East, and Africa (EMEA) can purchase documentation from
http://www.oraclebookshop.com/
Other customers can contact their Oracle representative to purchase printed documentation.
To download free release notes, installation documentation, Oracle Text code samples, white papers, or other collateral, please visit the Oracle Technology Network (OTN). You must register online before using OTN; registration is free and can be done at
http://technet.oracle.com/membership/index.htm
If you already have a username and password for OTN, then you can go directly to the documentation section of the OTN Web site at
http://technet.oracle.com/docs/index.htm
You can obtain Oracle Text technical information, collateral, code samples, training slides and other material at:
http://technet.oracle.com/products/text/
This section describes the conventions used in the text and code examples of this documentation set. It describes:
We use various conventions in text to help you more quickly identify special terms. The following table describes those conventions and provides examples of their use.
Code examples illustrate SQL, PL/SQL, SQL*Plus, or other command-line statements. They are displayed in a monospace (fixed-width) font and separated from normal text as shown in this example:
SELECT username FROM dba_users WHERE username = 'MIGRATE';
The following table describes typographic conventions used in code examples and provides examples of their use.
Oracle's goal is to make our products, services, and supporting documentation accessible to the disabled community with good usability. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For additional information, visit the Oracle Accessibility Program Web site at
http://www.oracle.com/accessibility/
JAWS, a Windows screen reader, may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, JAWS may not always read a line of text that consists solely of a bracket or brace.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|