just use :
break on col1 on col2 on col3
eg,
SQL> break on deptno on job
SQL> select deptno, job, ename
2 from emp
3 order by deptno, job
4 /
DEPTNO JOB ENAME
---------- --------- ----------
10 CLERK MILLER
MANAGER CLARK
PRESIDENT KING
20 ANALYST SCOTT
FORD
CLERK SMITH
ADAMS
MANAGER JONES
30 CLERK JAMES
MANAGER BLAKE
SALESMAN ALLEN
MARTIN
TURNER
WARD
"Jon Schlatter" <*jon-schlatter_at_stamats.com> wrote in message
news:tpd16f2k2ji2f_at_corp.supernews.com...
> 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
>
>
>
Received on Wed Sep 05 2001 - 18:20:16 CDT