Re: SQL Plus PL/SQL Syntax question

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.