Re: SQL*Plus break header

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
>
> I don't have any problem getting the value. The problem is
> formatting the BREAK ON column and an associated column so
> they print once on a separate line at the head of the break
> instead of being repeated on each line.
>
> If you have a solution using NEW_VALUE could you please be
> more specific?
>
> Many thanks,
>
> Phil

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
/

Hth

Sybrand Bakker
Senior Oracle DBA Received on Tue Nov 11 2003 - 10:36:21 CET