Re: hbest way to save html files in oracle ? clob ?

From: kilidire <yc_at_hwcn.org>
Date: Fri, 20 Apr 2001 02:22:52 GMT
Message-ID: <es6vdt43drg3iftn4apurl4erf9hdbhhb9@4ax.com>

Thanks Gelen,
But I had something else in mind. I need to be able to serve those files onto a website. 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') "

My question is , will a clob data type allow me to achieve that ? Thanks all.

On 19 Apr 2001 21:12:06 -0500, Galen Boyer <gboyer_at_primix.com> wrote:

>On Thu, 19 Apr 2001, yc_at_hwcn.org wrote:
>
>> hat about if I want to use it for updating an html daily with
>> an automatic process, like grab it from a place on the network
>> to update a page on the website. Also, would that be a good way
>> to implement a search engine for those clob html pages.
>>
>> Someting like if select html_page where html contains('clob') ;
>
>You might want to look into the Cartridge, context server.
>Oracle allows you to maintain many different formats of files in
>directories on the file system and then it will build an index
>table that can then be queried with the location of the file
>brought back as the output.
>
>Is this what you might be looking for?
  Received on Thu Apr 19 2001 - 21:22:52 CDT