Clob data type / html files / indexing

From: kilidire <yc_at_hwcn.org>
Date: Fri, 20 Apr 2001 02:30:19 GMT
Message-ID: <9c7vdtcqqun2gujjnupem0gup5trbi5ia3@4ax.com>

Hi all,
I need to be able to serve html files onto a website dynamically. Those files will be changing on a daily basis and will be available to me as html files on our intranet. I need to grab those files and insert them, maybe as clob files into the database and I also need to make them searchable on our external website.

3 things :
(1) Insert an html file as a clob data type into the db
(2) Replace it daily with a new one
(3) Make it searchable via sql queries such as :
" select html_page where html contains('sun ultra machine') "

Of course, this will apply to a bunch of files that need to be automated this way.

My question is , will a clob data type allow me to achieve that ? Thanks all. Received on Thu Apr 19 2001 - 21:30:19 CDT