Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Plus PL/SQL "break" question

Re: SQL Plus PL/SQL "break" question

From: Ms. D.H. Harvey <qq45_at_liverpool.ac.uk>
Date: 6 Sep 2001 08:24:14 GMT
Message-ID: <9n7bre$474$1@news.liv.ac.uk>


,In comp.databases.oracle.misc Jon Schlatter <*jon-schlatter_at_stamats.com> wrote:
: Is it possible to perform more than one "break" for a report with SQL Plus?
: I am working on a report that would be much more readable if I can reduce
: the amount of "duplicate" listings. Here is what it looks like now.

: clientname1 acctexec projectno1 jobno1
: acctexec projectno2 jobno1
: acctexec projectno 2 jobno3

: clientname2 acctexec projectno1 jobno1
: acctexec projectno1 jobno2
: acctexec projectno1 jobno3

: Here what I would like to see if possible.

: clientname1 acctexec projectno1 jobno1
: projectno2 jobno1
: jobno1

: clientname2 acctexec projectno1 jobno1
: jobno2
: jobno3

: As if it isn't obvious, I am a newbie. I hope I am asking this clearly
: enough.
: TIA for the help!
: Jon

break on clientname on acct on project

HTH Helen Received on Thu Sep 06 2001 - 03:24:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US