Search a context index using regular expression!
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.?