Oracle Text (MOSC)

MOSC Banner

Oracle Text (basic_lexer, skipjoins)

edited Dec 16, 2018 4:01AM in Oracle Text (MOSC) 3 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center