I have a table
create table EMAIL (
EMAIL_ID number primary key,
CLASS char(5),
CONTENT CLOB);
after indexing on CONTENT, i want to create a new field NEW_FIELD contains words from CONTENT in the root form and without stopwords.
for example :
record in CONTENT : I saw her standing there.
desirable new record in NEW_FIELD: see stand
need help..
thanks
create table EMAIL (
EMAIL_ID number primary key,
CLASS char(5),
CONTENT CLOB);
after indexing on CONTENT, i want to create a new field NEW_FIELD contains words from CONTENT in the root form and without stopwords.
for example :
record in CONTENT : I saw her standing there.
desirable new record in NEW_FIELD: see stand
need help..
thanks
Comment