Index Search Add FAQ Ask Question |
---|
$Date: 28-Dec-1996 $
$Revision: 1.0 $
$Author: Frank Naudé $
Topics
It allows one to access text information from database tables with standard SQL or via PL/SQL package calls.
text_enable = true
$ ctxsrv -user cxtsys/ctxsys_passwd -log ctx.log &
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;
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
| |