SQL*Plus reporting

From: s <s_at_b.c>
Date: 1998/04/22
Message-ID: <6hmh52$5qk$1@news.iinet.net.au>#1/1

Hi,

We are designing an application that needs to output several statistical and exception reports. One of our designers has suggested that we use the features of SQL*Plus (rather than Oracle Reports 2.5) to satisfy our requirements. The idea is that we can use the TEXT_IO package to write an SQL*Plus script which could then be executed using the HOST command. This will keep the processing on the server.

I have been looking at the features of SQL*Plus and have found it quite powerful, but it seems to have some restrictions with the layout of master-detail reports (ie the master data needs to be displayed in the TTITLE header).

Does anyone have experience with reporting using SQL*Plus that could show me a more elegant way of handling master-detail reports ? And is there a way of stopping a break column being padded with blanks when it is not displayed (it has the effect of adding a blank line to our reports).

Your help is much appreciated.

Natalina. Received on Wed Apr 22 1998 - 00:00:00 CDT