Oracle Text - Domain Index

oracle_text.sql

drop index ECOMMERCE.IX_NO_CLIENTE_OT;

update ECOMMERCE.CLIENTE set NM_CLIENTE = NM_CLIENTE || ' JOÃO' where CD_CLIENTE = 4;
update ECOMMERCE.CLIENTE set NM_CLIENTE = NM_CLIENTE || ' JOAO' where CD_CLIENTE = 5;
update ECOMMERCE.CLIENTE set NM_CLIENTE = NM_CLIENTE || ' joão' where CD_CLIENTE = 6;
update ECOMMERCE.CLIENTE set NM_CLIENTE = NM_CLIENTE || ' joao' where CD_CLIENTE = 7;

commit;


begin
ctx_ddl.create_preference('ctxsys.mylex', 'BASIC_LEXER');
ctx_ddl.set_attribute('ctxsys.mylex', 'BASE_LETTER', 'YES');
end;
/

create index ECOMMERCE.IX_NO_CLIENTE_OT on ECOMMERCE.CLIENTE(NM_CLIENTE) indextype  is ctxsys.context parameters('LEXER ctxsys.mylex');

select CD_CLIENTE, NM_CLIENTE from ECOMMERCE.CLIENTE where contains(NM_CLIENTE, 'joao') > 0;
select CD_CLIENTE, NM_CLIENTE from ECOMMERCE.CLIENTE where contains(NM_CLIENTE, 'joão') > 0;
select CD_CLIENTE, NM_CLIENTE from ECOMMERCE.CLIENTE where contains(NM_CLIENTE, 'JOAO') > 0;
select CD_CLIENTE, NM_CLIENTE from ECOMMERCE.CLIENTE where contains(NM_CLIENTE, 'JOÃO') > 0;