DROP TABLE quick;
CREATE TABLE quick ( 
    quick_id                NUMBER
      CONSTRAINT quick_pk   PRIMARY KEY,
    text                    VARCHAR2(80)); 


INSERT INTO quick ( quick_id, text )
  values ( 1, 'The cat sat on the mat' ); 
INSERT INTO quick ( quick_id, text )
  values ( 2, 'The quick brown fox jumps over the lazy dog' ); 
COMMIT;


DROP INDEX quick_text;
CREATE INDEX quick_text ON quick(text) 
 INDEXTYPE IS CTXSYS.CONTEXT;


SELECT index_name, index_type
  FROM user_indexes
  WHERE index_name LIKE 'QUICK%';


Configure SQL*NET


SELECT text FROM quick
WHERE CONTAINS (text, 'sat on') > 0;

SELECT SCORE(4)s, text FROM quick
WHERE CONTAINS (text, 'dog', 4) >= 0;


************ LISTENER **************
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = chinf-wfn2236d)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = extproc))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = extproc)
      (ORACLE_HOME = D:\Oracle\Ora81)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ora8i)
      (ORACLE_HOME = D:\Oracle\Ora81)
      (SID_NAME = ora8i)
    )
  )




*************** TNSNAMES ********************

ORA8I =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = chinf-wfn2236d)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(Key = ora8i))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ora8i)
    )
  )

EXTPROC_CONNECTION_DATA, EXTPROC_CONNECTION_DATA.world  =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = extproc)
    )
  )
***********************************





