Index   Search   Add FAQ   Ask Question  

Oracle ConText Option/ Intermedia FAQ

$Date: 28-Dec-1996 $
$Revision: 1.0 $
$Author: Frank Naudé $

Topics

  • What is the Oracle ConText Option?
  • How does one enable the ConText Option?
  • How does one use the ConText Option?

  • Back to Oracle FAQ Index

    What is the Oracle ConText Option?

    The Oracle ConText Option (OCO) is a text-management and analysis extension to the Oracle database server that will eventually replace the Oracle TextServer Option.

    It allows one to access text information from database tables with standard SQL or via PL/SQL package calls.

  • Back to top of file

  • How does one enable the ConText Option?

  • Install Oracle ConText Option Software
  • Enable the ConText INIT.ORA Parameter:
       text_enable = true
    
  • Start a ConText server process:
       $ ctxsrv -user cxtsys/ctxsys_passwd -log ctx.log &
    
  • Back to top of file

  • How does one use the ConText Option?

    From SQL*Plus, build an index on a database column containing text:
      SQL> execute ctx_ddl.create_policy('RESUME_POLICY', EMP.RESUME);
      SQL> execute ctx_ddl.create_index('RESUME_POLICY');
    
    Then, issue your SELECT statement:
      SELECT resume FROM emp WHERE CONTAINS (resume, 'DBA') > 0;
    

  • Back to top of file

  • General: Home | Index | Preamble | Glossary | OraCorp | Papers | Fun | News | Events | Y2000 | Books | Links | Forums
    Products: SQL | Plus | Loader | PL/SQL | PreComp | OPO | OMO | OO4OLE | DBA | PQO | PSO | OCO | Net | ODBC | WebServer | Des2k | Dev2k
    Systems: MVS | Unix | Windows | WindowsNT | NetWare | VMS