690 shaares
3 liens privés
3 liens privés
GRANT EXECUTE ON CTXSYS.CTX_DDL TO test;
CREATE TABLE test_tab (company_name VARCHAR2 (60));
INSERT ALL
INTO test_tab VALUES ('CONSULTING')
INTO test_tab VALUES ('LW CONSULTING')
INTO test_tab VALUES ('LW CONSULTING INC')
INTO test_tab VALUES ('LW CONSULTING INC.')
INTO test_tab VALUES ('LW CONSULTING, INC.')
INTO test_tab VALUES ('LW CONSULTING, INC.')
INTO test_tab VALUES ('ORACLE CORPORATION')
SELECT * FROM DUAL;
EXEC CTX_DDL.CREATE_INDEX_SET ('company_set');
CREATE INDEX idx_company ON test_tab (company_name) INDEXTYPE IS CTXSYS.CTXCAT PARAMETERS ('INDEX SET company_set');