Hi
Toad 14.1.120.923
Noticed that Toad reports an error for the following statement. But actually this is valid syntax and execution succeeds.
Basically this syntax is valid from 12.2 onwards for json full text search indexes.
-- 12.1 syntax
CREATE INDEX TOIMINGUD_JSON_SISU ON TOIMINGUD (JSON_SISU) INDEXTYPE IS CTXSYS.CONTEXT
PARAMETERS ('LEXER MYLEX SECTION GROUP CTXSYS.JSON_SECTION_GROUP SYNC (ON COMMIT)');-- 12.2 syntax
CREATE SEARCH INDEX TOIMINGUD_JSON_SISU ON TOIMINGUD (JSON_SISU) FOR JSON;
Regards
Raul