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


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