DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: SQL output in HTML format

  1. 04-08-2003, 09:33 AM #1
    topstar
    topstar is offline Junior Member
    Join Date
    May 2001
    Posts
    55

    SQL output in HTML format

    I have got a table with 3 rows and a few hundred columns.

    Can I get the formatting required in the SQL statement to generate the output of this table in html format such that when viewed in a HTML viewer, we see the 3 columns and all the rows inside a table, complete with borders? Is it possible to do this? If so can someone tell me how?

    Cheers
    A farmer learns more from a bad harvest than a good one
    Reply With Quote Reply With Quote
  2. 04-08-2003, 09:57 AM #2
    sreddy's Avatar
    sreddy
    sreddy is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Try iSQL*Plus if you are using latest version of Oracle.
    Reddy,Sam
    Reply With Quote Reply With Quote
  3. 04-08-2003, 10:12 AM #3
    topstar
    topstar is offline Junior Member
    Join Date
    May 2001
    Posts
    55
    I am using Oracle 8.1. I dont think that is available in 8.1 ?
    A farmer learns more from a bad harvest than a good one
    Reply With Quote Reply With Quote
  4. 04-08-2003, 10:24 AM #4
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Take a look PL/SQL web toolkit and PSP's

    http://download-west.oracle.com/docs...eb.htm#1002783

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  6. 04-08-2003, 10:46 AM #5
    Tarry's Avatar
    Tarry
    Tarry is offline Senior Advisor
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Try Query Reporter, It's Free and a good tool.

    http://www.allroundautomations.nl/queryreporter.html
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---
    Reply With Quote Reply With Quote
  7. 04-08-2003, 11:12 AM #6
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    lsc@DEV817-ES7J2BKT8ZM0YY>set markup

    Usage: SET MARKUP HTML [ON|OFF] [HEAD text] [BODY text]
    [ENTMAP {ON|OFF}] [SPOOL {ON|OFF}] [PRE[FORMAT] {ON|OFF}]
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width