Re: SQL Plus PL/SQL "break" question

From: Ranga Chakravarthi <ranga_at_cfl.rr.com>
Date: Wed, 05 Sep 2001 23:20:16 GMT
Message-ID: <Qqyl7.38534$aZ.10582699@typhoon.tampabay.rr.com>

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