By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table_name ( value ) AS
SELECT 'search in this text' FROM DUAL UNION ALL
SELECT '"in this text, you should search" said Yoda' FROM DUAL UNION ALL
SELECT 'searching text is hard' FROM DUAL UNION ALL
SELECT 'we do not want to find text research' FROM DUAL
4 rows affected
CREATE INDEX table_name__value__textidx ON table_name(value) INDEXTYPE IS CTXSYS.CONTEXT;
select *
from table_name
where CONTAINS( value, '$search AND text', 1 ) > 0;
| VALUE |
|---|
| search in this text |
| "in this text, you should search" said Yoda |
| searching text is hard |