CREATE TABLE MY_TABLE (
ID NUMBER,
COL VARCHAR2(15 CHAR),
CONSTRAINT PK_MY_TABLE PRIMARY KEY (ID)
) Table created.
INSERT INTO MY_TABLE VALUES (1, 'ruben')1 row(s) inserted.
INSERT INTO MY_TABLE VALUES (2, 'rubén')1 row(s) inserted.
INSERT INTO MY_TABLE VALUES (3, 'Ruben')1 row(s) inserted.
INSERT INTO MY_TABLE VALUES (4, 'Rubén')1 row(s) inserted.
INSERT INTO MY_TABLE VALUES (5, 'RUBEN')1 row(s) inserted.
INSERT INTO MY_TABLE VALUES (6, 'RUBÉN')1 row(s) inserted.
COMMIT Statement processed.
CREATE INDEX IDX_MY_TABLE_01 ON MY_TABLE(COL) INDEXTYPE IS CTXSYS.CONTEXT Index created.
SELECT ID,COL FROM MY_TABLE WHERE CONTAINS(COL, 'ruben') > 0| ID | COL | 1 | ruben | 3 | Ruben | 5 | RUBEN |
|---|
BEGIN
CTX_DDL.CREATE_PREFERENCE ('MY_LEXER', 'BASIC_LEXER');
CTX_DDL.SET_ATTRIBUTE ('MY_LEXER', 'BASE_LETTER', 'YES');
END;Statement processed.
DROP INDEX IDX_MY_TABLE_01 Index dropped.
CREATE INDEX IDX_MY_TABLE_01 ON MY_TABLE(COL) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS ('LEXER MY_LEXER')Index created.
SELECT ID,COL FROM MY_TABLE WHERE CONTAINS(COL, 'ruben') > 0| ID | COL | 1 | ruben | 2 | rubén | 3 | Ruben | 4 | Rubén | 5 | RUBEN | 6 | RUBÉN |
|---|