Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Storing HTML pages in Oracle
Oracle has the tool named Web Publishing Assistant which automaticaly
regenerates web pages (HTML files) as the database changes. To view these
files from within oracle, define them as a column of type BFILE. BFILE
columns are read-only and cannot be modified by use of PL/SQL. They can,
however, be viewed through DBMS_LOB package. It's all described in the
application developers guide.
Web Publishing Assistant comes with the database. It is a packaged tool that
doesn't need to be purchased separately. I find it extremely useful.
Mladen Gogala
In article <6dhp1r$nue$1_at_news1.fast.net>,
mzawadzki_at_starnet.lenfest.com wrote:
>
> 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.
>
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Mar 05 1998 - 00:00:00 CST
![]() |
![]() |