Oracle text procedure?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • leli loh
    New Member
    • Apr 2009
    • 2

    Oracle text procedure?

    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
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    i am not sure what exactly you are looking for .

    Comment

    • leli loh
      New Member
      • Apr 2009
      • 2

      #3
      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.

      Comment

      Working...