SELECT * FROM DBA_DIRECTORIES;

ALTER SYSTEM SET UTL_FILE_DIR='C:\Mis\Imaqenes' SCOPE=SPFILE;

##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################
 
###########################################
# Cache and I/O
###########################################
db_block_size=8192
db_file_multiblock_read_count=32
 
###########################################
# Cursors and Library Cache
###########################################
open_cursors=300
 
###########################################
# Database Identification
###########################################
db_domain=WORLD
db_name=ORCL

# ... Etc ...
...
...
utl_file_dir=C:\Mis\Imagenes
...
###########################################

SCOTT@orcl_11gR2> CREATE TABLE tabla
  2    (detalle  CLOB)
  3  /

Table created.

SCOTT@orcl_11gR2> INSERT ALL
  2  INTO tabla VALUES ('criterio palabra2 palabra3')
  3  INTO tabla VALUES ('palabra1 criterio palabra3')
  4  INTO tabla VALUES ('palabra1 palabra2 criterio')
  5  INTO tabla VALUES ('otros palabras')
  6  SELECT * FROM DUAL
  7  /

4 rows created.

SCOTT@orcl_11gR2> CREATE INDEX tabla_detalle_idx
  2  ON tabla (detalle)
  3  INDEXTYPE IS CTXSYS.CONTEXT
  4  /

Index created.

SCOTT@orcl_11gR2> SELECT * FROM tabla
  2  WHERE  CONTAINS (detalle, 'criterio') > 0
  3  /

DETALLE
--------------------------------------------------------------------------------
criterio palabra2 palabra3
palabra1 criterio palabra3
palabra1 palabra2 criterio

3 rows selected.

SCOTT@orcl_11gR2>

SCOTT@orcl_11gR2> BEGIN
  2   CTX_DDL.CREATE_PREFERENCE ('directorio', 'FILE_DATASTORE');
  3   ctx_DDL.SET_ATTRIBUTE ('directorio', 'PATH', 'c:\my_oracle_files');
  4  END;
  5  /

PL/SQL procedure successfully completed.

SCOTT@orcl_11gR2> CREATE TABLE tabla
  2    (id	    NUMBER,
  3  	documentos  VARCHAR2(15))
  4  /

Table created.

SCOTT@orcl_11gR2> INSERT INTO tabla VALUES (1, 'primero.doc')
  2  /

1 row created.

SCOTT@orcl_11gR2> INSERT INTO tabla VALUES (2,'segundo.doc')
  2  /

1 row created.

SCOTT@orcl_11gR2> CREATE INDEX indice ON tabla (documentos)
  2  INDEXTYPE IS CTXSYS.CONTEXT
  3  PARAMETERS ('DATASTORE directorio')
  4  /

Index created.

SCOTT@orcl_11gR2> EXEC CTX_DOC.SET_KEY_TYPE ('ROWID')

PL/SQL procedure successfully completed.

SCOTT@orcl_11gR2> COLUMN palabras_en_su_contexto FORMAT A45 WORD_WRAPPED
SCOTT@orcl_11gR2> SELECT id, documentos,
  2  	    CTX_DOC.SNIPPET ('indice', ROWID, 'palabra%')
  3  	      AS palabras_en_su_contexto
  4  FROM   tabla
  5  WHERE  CONTAINS (documentos, 'palabra%') > 0
  6  /

        ID DOCUMENTOS      PALABRAS_EN_SU_CONTEXTO
---------- --------------- ---------------------------------------------
         1 primero.doc     criterio <b>palabra2</b> <b>palabra3</b>


         2 segundo.doc     <b>Palabra1</b> criterio <b>palabra3</b>



2 rows selected.

SCOTT@orcl_11gR2>

AppID := DDE.App_Begin('C:\WinApp\OpenOffice\OpenOffice.org 3\program\swriter.exe Z:\'||nombre,DDE.App_Mode_Normal);