Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2002
    Posts
    833

    Unanswered: sql functionality or tool for putting out data in htm

    hi,

    would like to know if there is any tool or package to put out the select statement data in htm forms or the like

    TIA
    osy45

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: sql functionality or tool for putting out data in htm

    Originally posted by osy45
    hi,

    would like to know if there is any tool or package to put out the select statement data in htm forms or the like

    TIA
    osy45
    Have a look at the Oracle supplied package called HTP.

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

    Talking Re: sql functionality or tool for putting out data in htm

    Originally posted by osy45
    hi,

    would like to know if there is any tool or package to put out the select statement data in htm forms or the like

    TIA
    osy45
    The following works OK for me.


    column lastname format a16
    column home_phone format a16
    column mobile format a12
    column department format a24
    set lines 131 pages 80 echo off term off feedback off
    set markup HTML on pre on spool on
    spool /opt/netscape/docs/bcm/phonelist.html
    select
    --EP.AKA FIRSTNAME, EMP.LASTNAME, TTL.JOBLONG title, DPT.DEPTLONG Department, EP.Phone
    NVL(EP.AKA,EMP.FIRSTNAME) FIRSTNAME, EMP.LASTNAME, TTL.JOBLONG title, EP.Phone Home_Phone, HM.Mobile_num Mobile
    --NVL(EP.AKA,EMP.FIRSTNAME) 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,
    home_mobile HM,
    hr.epersonal_master EP
    where EMP.A_I = 'A'
    and ORG.DEPARTMENT in ('100','112','114','117','120','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
    and EP.PHONE = HM.HOME_NUM
    order by 2
    /

    spool off
    exit

    Will this get you close to an acceptable solution?

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: sql functionality or tool for putting out data in htm

    Originally posted by anacedent
    set markup HTML on pre on
    I've learned something today!

  5. #5
    Join Date
    Nov 2002
    Posts
    833

    Re: sql functionality or tool for putting out data in htm

    Originally posted by andrewst
    I've learned something today!
    your anwsers gave me the clue where to start

    thanks
    osy45

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •