Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table mj_lacts
as
select
  level as id,
  lpad(level, 100, '0') as title,
  lpad(level, 4000, '0') as large_col
from dual
connect by level < 10
9 rows affected

insert into mj_lacts
values(1, 'some text and law word', 'a')
1 rows affected

SELECT *
FROM Mj_lacts
WHERE CATSEARCH(TITLE, 'law*', NULL) > 0
ORA-20000: Oracle Text error:
DRG-10599: column is not indexed

CREATE INDEX LACT_TITLE_TI ON MJ_LACTS(TITLE) 
       INDEXTYPE IS ctxsys.CTXcat;
SELECT *
FROM Mj_lacts
WHERE CATSEARCH(TITLE, 'law*', NULL) > 0


ID
TITLE
LARGE_COL


1
some text and law word
a