Forum Stats

  • 3,781,122 Users
  • 2,254,483 Discussions
  • 7,879,578 Comments

Discussions

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.?


Tagged:
This discussion has been closed.