Re: PLSQL syntax question

Ranga,
Sorry to be so dense. I understand now what you meant, someone reponded with a link to an Oracle page with a description and I read more in depth. It's hard being a newbie sometimes!
Thanks

"Jon Schlatter" <*jon-schlatter_at_stamats.com> wrote in message news:tol4qljvgju1da_at_corp.supernews.com...
> I tried this and it is not giving me the type of results I need. Let me
see
> if I can explain better. Currently my report looks like this.
>
> Client1 Project1 Description
> Client1 Project2 Description
> Client1 Project3 Description
> Client2 Project1 Description
> Client2 Project2 Description
> Client2 Project3 Description
>
> What I want to see is like this.
>
> Client1 Project1 Description
> Project2 Description
> Project3 Description
> Client2 Project1 Description
> Project2 Description
> Project3 Description
>
> Can I do this with SQL Plus - PL/SQL?
>
> "Ranga Chakravarthi" <ranga_at_cfl.rr.com> wrote in message
> news:xmvi7.78461$0X.15154363_at_typhoon.tampabay.rr.com...
> > If you are using SQL*Plus, try the break command
> > break on customer_ref
> >
> > SQL> break on deptno
> > SQL> select deptno, ename from emp order by deptno;
> >
> > DEPTNO ENAME
> > ---------- ----------
> > 10 CLARK
> > KING
> > MILLER
> > 20 SMITH
> > ADAMS
> > FORD
> > SCOTT
> > JONES
> > 30 ALLEN
> > BLAKE
> > MARTIN
> > JAMES
> > TURNER
> > WARD
> >
> > 14 rows selected.
> >
> > SQL>
> > "Jon Schlatter" <*jon-schlatter_at_stamats.com> wrote in message
> > news:tokr58jmtcfu84_at_corp.supernews.com...
> > > I need to perform a select statement that does a group by and the
> > supresses
> > > duplicate entries. I am writing a job status report and have the
> following
> > > select statemenet written.
> > >
> > > SELECT PA_JOB.PROJECT_NO, PA_JOB.JOB_NO, PA_JOB.DES1,
> > > PA_JOB.JOB_MANAGER_REF, PA_JOB.EST_COMPLETION_DATE,
> PA_JOB.DEADLINE_DATE,
> > > PA_JOB.CUSTOMER_REF, PA_JOB.UD_NOTE
> > > FROM K.PA_JOB PA_JOB
> > > WHERE ( PA_JOB.STATUS IN ('A','I') )
> > > ORDER BY PA_JOB.CUSTOMER_REF ASC, PA_JOB.JOB_MANAGER_REF ASC,
> > > PA_JOB.PROJECT_NO ASC, PA_JOB.JOB_NO ASC
> > >
> > > All the data shows up properly, but now I need to supress duplicate
> > entries
> > > on the PA_JOB.CUSTOMER_REF field for readability. Can anyone help me?
> > >
> > > TIA
> > > Jon
> > >
> > >
> > >
> > >
> >
> >
>
>
Received on Tue Aug 28 2001 - 05:45:53 CEST