-- 17
drop index TEXT_INDEX;

begin
 ctx_ddl.create_preference('lex_z_m','BASIC_LEXER');
 ctx_ddl.set_attribute('lex_z_m',
 'printjoins', '_-  ');
 ctx_ddl.set_attribute ('lex_z_m',
 'index_text', 'YES');
end;

create index indeks_z_myslnikami
on QUOTES( TEXT ) indextype is ctxsys.context
parameters ( 'LEXER lex_z_m' );

-- 18
select Q.TEXT
from QUOTES Q
where CONTAINS(Q.TEXT,'humans')>0;

-- 19
select Q.TEXT
from QUOTES Q
where contains(Q.TEXT, 'non\-humans')>0;