Re: "Publishing" HTML

From: Charlie Mengler <charliem_at_mwh.com>
Date: Mon, 10 Sep 2001 09:54:47 -0700
Message-ID: <F001.003884BA.20010910091523@fatcity.com>

Below is the solution that was implemented & is now in production.

Scott Graves wrote:
>
> To produce a simple page, at the sqlplus prompt type "set markup html on"
> then issue your query and spool it to a file.
>

#!/usr/bin/ksh
# Formats a simple webpage for an emergency call list.
#
. ${HOME}/oracle.chiron.HR.env     

sqlplus -silent <<EOF
username/password
column lastname format a16
column phone format a16
column department format a24
set lines 140 pages 60 echo off term off feedback off set markup HTML on pre on spool on
spool /opt/netscape/docs/bcm/phonelist.html

      select EMP.FIRSTNAME, EMP.LASTNAME, TTL.JOBLONG title, DPT.DEPTLONG Department, EP.Phone

      from hr.empheader_master EMP,
           hr.eorg_master ORG,
           hr.jobnumber TTL,
           hr.depart DPT,
           hr.ejobsal_master JOB,
           hr.epersonal_master EP
      where EMP.A_I = 'A'
       and  ORG.DEPARTMENT in ('100','112','117','121','122','138')
       and  ORG.DEPARTMENT = DPT.DEPTCODE
       and  EMP.SSN = JOB.SSN
       and  EMP.SSN = ORG.SSN
       and  JOB.JOBNUMBER = TTL.JOBCODE
       and  EMP.SSN = EP.SSN

   order by 2
/
spool off
exit
EOF

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: charliem_at_mwh.com

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: ListGuru_at_fatcity.com (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).

Received on Mon Sep 10 2001 - 11:54:47 CDT