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_at_typhoon.tampabay.rr.com>
"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 Thu Sep 06 2001 - 01:20:16 CEST
Date: Wed, 05 Sep 2001 23:20:16 GMT
Message-ID: <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
---------- --------- ----------
[Quoted] 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 Thu Sep 06 2001 - 01:20:16 CEST