Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Plus PL/SQL Syntax question
That should set me on the right track.
Thanks much.
Jon
"Galen Boyer" <galenboyer_at_hotpop.com> wrote in message
news:u8zg4ivwb.fsf_at_verizon.net...
> On Mon, 27 Aug 2001, *jon-schlatter_at_stamats.com wrote:
>
> > 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 in SQL Plus PL/SQL?
>
> You can use "break on ..." statement in sqlplus to get the single
> values for first column
>
>
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/
a82950/ch4.htm#1001538
>
> I'm not too sure how to get the extra spaces added in the
> subsequent rows though.
> --
> Galen Boyer
> It seems to me, I remember every single thing I know.
Received on Mon Aug 27 2001 - 22:43:34 CDT