SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Search a context index using regular expression!

672015Nov 23 2008

I have a table named "DATA1" contains about 7000 row
DATA1
NAME TYPE
-----------------------------------
ID NUMBER
TEXT CLOB
CODE VARCHAR2(32)

i have ceated an context index on "text" column named "TEXT_INDEX".i want to query index to get only the text from text column contains email adress,i try to use regular expression in my query but it failed.
i dont want to query all records to get email .
i there any way to do this using the index.?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 21 2008

Added on Nov 23 2008

#index, #query

0 comments

211 views