Oracle Text (basic_lexer, skipjoins)
Hi all,
I am looking for help in getting Oracle TEXT to skip special characters from the source data. For example, given the standard HR.EMPLOYEES table, I create a new table and one additional row as follows:
create table employees2 as select * From employees;
insert into employees2 values (-1, 'Ro b.e,r(s-on)', 'hello','world', '650.121.2019', '12-FEB-06', 'ST_CLERK', 2700,null ,123 ,50);
insert into employees2 values (-2, 'Rob.e,r(s-on)', 'hello','kitty', '650.121.2019', '12-FEB-06', 'ST_CLERK', 2700,null ,123 ,50);
commit;
I am trying to write a text query that can pull the newly inserted row.