Re: Storing HTML pages in Oracle

From: <mzawadzki_at_starnet.lenfest.com>
Date: 1998/03/03
Message-ID: <6dhp1r$nue$1@news1.fast.net>#1/1

Use SQL*PLUS with correct settings and spool. I can even see using the 'title' to enforce a page ... eg . TTITLE CENTER '<HEAD>....&BEGDATE</HTML>' any way consult your SQL*PLUS docs

Minimumly you would use:

REM no column headers
set head off
REM no page breaks
set pagesize 0
REM very long lines allowed
set linesize 9999
REM suppress console output
set termout off
REM get rid of 1 row selected and the like set feedback off
REM make sure SQL*PLUS doesn't have trouble with & set verify off
REM make sure we don't see the select statement in the spool file set echo off
REM trim whitespace at end of each line
set trimspool on
spool 'yourfile.html'
select ....;
spool off

Anatolii Belomestnov <abelomestnov_at_snet.net> wrote:

>Robin,

>A good option is using Perl5 with DBI,DBD::Oracle installed.
>you can easily pull your HTML out of the Oracle Tables and
>put them into files. Refer to perl.org for Perl info.

>Oh, by the way you can also use FILE_UTIL package on Oracle to create
>files. That way could be just perfect too.

>Anatolii

>Robin Reese wrote:
>>
>> I'm storing HTML pages in Oracle, 1 row = 1 line in an HTML file. I'm
>> creating the table using stored procedures.
>>
>> My problem is how to extract the pages from Oracle back to an HTML file
>> (ie no headings etc). Also I will be replacing about 100 pages each
>> night and I would like be able to store each HTML separately.
>>
>> What I would like to do is select all pages and write to a flat file.
>> When the key changes I want the flat file name to change too.
>>
>> Is this possible? Is there an easier way to do this?
>>
>> Thanks,
>> Robin

>--

>---------------------------------------------------------
>Anatolii Belomestnov <anatolii.belomestnov_at_gecapital.com>
>---------------------------------------------------------

Mark Zawadzki, late of Waynesboro, Va.
'...there is not a sprig of grass that shoots uninteresting to me.'

                                                 Thomas Jefferson, 1790.

Received on Tue Mar 03 1998 - 00:00:00 CST