[thesite] meta description
Dean Mah
dmah at shaw.ca
Mon Jan 21 10:03:25 CST 2002
DBMS_LOB is a standard Oracle package. I use it currently to search
the tip bodies. It's as simple as adding:
DBMS_LOB.INSTR(column, search_string) <> 0
to your queries. Unforuntately, this is a case-sensitive search.
You can't search LONGs, as far as I know, without creating your own
PL/SQL stored procedure or using either Oracle7's ConText option or
Oracle8+'s interMedia Text.
Dean
Warden, Matt writes:
> On Jan 19, .jeff had something to say about RE: [thesite] meta description
>
> >rudy,
> >
> >><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> >> From: rudy
> >>
> >> does our article search search both synopsis and
> >> contents?
> >><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> >
> >no, it currently only searches the synopsis because you can't
> >perform a LIKE on a long datatype. hopefully moving towards a clob
> >will solve this shortfall. either way it doesn't really matter
> >because i have some ideas regarding search for v3.0 anyway.
>
> you can't perform a LIKE on a CLOB either. In fact, as i understand
> it, there is more support for searching LONGs than there is for
> searching LOBs. To search a LOB, you need a package called DBMS_LOB
> (not 100% sure on the name, but it's something like that).
More information about the thesite
mailing list