Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQL*Plus report and Web Server

SQL*Plus report and Web Server

From: Darla Higgins <higginsd%csc_at_mhs.edwards.af.mil>
Date: Wed, 02 Dec 1998 16:27:25 -0800
Message-ID: <3665DAED.33B2F015@edwards.af.mil>


Has anyone ported existing SQL*Plus 3.0 reports to the WebServer 2.1 or OAS 3.0?
We have about 300 SQL*Plus 3.0 reports which we want to move to the Web.

Each report has a front end screen to gather report parameters. These screens can be easily duplicated using the Web PL/SQL toolkit. However, we want to run the reports using SQL*Plus and send the formatted output back to the browser. I know how to create the SQL statements to return the results back to the browser in an HTML table. However, all of the existing reports make extensive use of SQL*Plus Column, Break, and Sort commands to provide subtotals and totals. We do not want to lose this formatting and grouping that SQL*Plus provides. Any ideas??

    Darla Higgins Received on Wed Dec 02 1998 - 18:27:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US