Re: SQL Plus PL/SQL "break" question

"Ranga Chakravarthi" <ranga_at_cfl.rr.com> a écrit dans le message news: Qqyl7.38534$aZ.10582699_at_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
> >

And if you want a blank line you can use the skip parameter:

v815> break on deptno skip 1 on job
v815> select deptno, job, ename from emp order by deptno, job;

    DEPTNO JOB ENAME
---------- --------- ----------

        10 CLERK     MILLER
           MANAGER   CLARK
           PRESIDENT KING

        20 ANALYST   FORD
                     SCOTT
           CLERK     SMITH
                     ADAMS
           MANAGER   JONES

        30 CLERK     JAMES
           MANAGER   BLAKE
           SALESMAN  MARTIN
                     ALLEN
                     WARD
                     TURNER

14 rows selected.

--
Have a nice day
Michel