Chris:
If you know some basic HTML, I would think the best way would be to send the
output of the query to a file via UTL_FILE, formatting it into HTML along
the way. I saw a Oracle sales geek do this once demonstrating how to use
DBMS_JOB and UTL_FILE to refresh static web pages on a website on a periodic
basis.
Jon Walthour
-----Original Message-----
Sent: Friday, September 07, 2001 11:56 AM
To: Multiple recipients of list ORACLE-L
On a good day, I'm challenged to spell HTML so I need advice.
I have a strightforward SQL query that produces our internal phone list. I'd
like to make this data available on our Intranet.
What is the simplest way for me to "webify" this output?
This can really be a static webpage; rather than doing a
real time DB query anytime somebody wants to look at the
phone list on the web.
TIA & HAND!
--
Charlie Mengler Maintenance Warehouse
[EMAIL PROTECTED] 10641 Scripps Summit Ct.
858-831-2229 San Diego, CA 92131
Data-free analysis results in a success-free history.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Charlie Mengler
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from). You may also send the HELP
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Walthour, Jon (GEAE, Compaq)
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
