Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> SQL*Plus report and Web Server
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
![]() |
![]() |