Re: SQL*Plus break header

sybrandb_at_yahoo.com wrote in message news:<a1d154f4.0311110136.73ef31a_at_posting.google.com>...
[Quoted] > pbewig_at_swbell.net (Phil Bewig) wrote in message news:<455f7154.0311101753.1a54a17b_at_posting.google.com>...
> > Frank <fbortel_at_home.nl> wrote in message news:<booukh$ll8$1_at_news4.tilbu1.nb.home.nl>...
> > > Phil Bewig wrote:
> > >
> > > > I am using SQL*Plus and ordinary SQL (no PL/SQL) to create a
> > > > report. I would like to write a header line each time a field
> > > > breaks:
> > > Something like 'new value' pops to mind
> The new_value solution typically comes into play when you want to use
> the column value in a title. Otherwise it isn't of much use.
> To avoid repeating you simply need to use the nodup(licates) clause of
> the break command.
> If you want to use the value in a title you need to have
>
> column bar new_value _bar noprint
> ttitle "current value of bar is &_bar" center skip 2
> break on bar skip page nodup
> select bar, <whatever you want>
> from foo
> /

I know about master/detail reports that put the break field in the ttitle. However, I have many small accounts, and don't want to start a new page for each one.

Thanks again to all who have responded, and thanks in advance for any additional help you can provide.

Phil Received on Tue Nov 11 2003 - 15:26:45 CET