Hello,
I think you can use a fulltext index and a regex:
select * from table where match( ftfield) against ('+interests
+reading' in boolean mode) and ftfield rlike your regexp
or
select * from table where match( ftfield) against ('+interests
+reading' in boolean mode) having ftfield rlike yo
ty, can oracle do such things? I'm kind of
> far away from oracle but
> not too long ago I learned there is no way that I can store long
> text and using sql query
> the text in oracle tables.
> - Original Message -----
> From: [EMAIL PROTECTED]
> To
st
Sent: Friday, October 08, 2004 8:15 AM
Subject: Re: data with dynamic schema stored in a column as a property list.
Have you considered a combination of Full-text indexing (to quickly locate
a subset of records that may match your criteria) and regular expression
matching (to elimina
Have you considered a combination of Full-text indexing (to quickly locate
a subset of records that may match your criteria) and regular expression
matching (to eliminate the non-matching results from the results of the
full-text search)? I know it's two steps but your "data" is practically
op
Hi, instead of xml, i stored arbitrary data of the form
(the actual usage of such mechanism is for more fancy stuff,
say, dynamic configuration, otherwise this is really not necessary)
{
name = "Fn, Ln"; // string value
gender = F;
Hi, instead of xml, i stored arbitrary data of the form
(the actual usage of such mechanism is for more fancy stuff,
say, dynamic configuration, otherwise this is really not necessary)
{
name = "Fn, Ln"; // string value
gender = F;
