Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!rip!news.webusenet.com!peer01.cox.net!cox.net!news.maxwell.syr.edu!postnews1.google.com!not-for-mail
From: pbewig@swbell.net (Phil Bewig)
Newsgroups: comp.databases.oracle.tools
Subject: Re: SQL*Plus break header
Date: 11 Nov 2003 06:26:45 -0800
Organization: http://groups.google.com
Lines: 30
Message-ID: <455f7154.0311110626.ba967e0@posting.google.com>
References: <455f7154.0311101302.310abb98@posting.google.com> <booukh$ll8$1@news4.tilbu1.nb.home.nl> <455f7154.0311101753.1a54a17b@posting.google.com> <a1d154f4.0311110136.73ef31a@posting.google.com>
NNTP-Posting-Host: 155.106.253.1
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1068560806 5339 127.0.0.1 (11 Nov 2003 14:26:46 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 11 Nov 2003 14:26:46 +0000 (UTC)
Xref: newssvr20.news.prodigy.com comp.databases.oracle.tools:83485

sybrandb@yahoo.com wrote in message news:<a1d154f4.0311110136.73ef31a@posting.google.com>...
> pbewig@swbell.net (Phil Bewig) wrote in message news:<455f7154.0311101753.1a54a17b@posting.google.com>...
> > Frank <fbortel@home.nl> wrote in message news:<booukh$ll8$1@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