Connecting Tech Pros Worldwide Help | Site Map

Oracle text procedure?

Newbie
 
Join Date: Apr 2009
Posts: 3
#1: Apr 13 '09
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
debasisdas's Avatar
Moderator
 
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,504
#2: Apr 13 '09

re: Oracle text procedure?


i am not sure what exactly you are looking for .
Newbie
 
Join Date: Apr 2009
Posts: 3
#3: Apr 13 '09

re: Oracle text procedure?


my question is, how can i process the clob file in CONTENT with the result that every words become the root form, the stopwords are skipped (ignored), and it's saved as a new record (in other table or field).

can it be processed just after indexing?or i must do anything before?can some procedure do the process?

thanks for your attention.
Reply

Tags
clob, oracle, stem, stopword, text