Skip to Main Content

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


Comments

I think you mean "odd numbered".
Anyway, here is an example:
select * from (select ename,job, ROWNUM AS rn from emp) where mod(rn, 2) <> 0;

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 21 2008
Added on Nov 23 2008
0 comments
210 views