Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Plus PL/SQL Syntax question

Re: SQL Plus PL/SQL Syntax question

From: Jon Schlatter <*jon-schlatter_at_stamats.com>
Date: Mon, 27 Aug 2001 22:43:34 -0500
Message-ID: <tom4c24t77hr4f@corp.supernews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US