Re: SQL PLus question.... can ya help?

Oops, seems like Remarq doesn't want to cooperate. I want each returned record to be on it's own line, with no blank lines in between....

In article <01429068.88964dca_at_usw-ex0102-084.remarq.com>, hookem94 <gti_vr6NOgtSPAM_at_yahoo.com.invalid> wrote:
>
>
>
>Hi
>I was wondering if someone could shed some light on this. I
>don't have a lot of SQL Plus experience (this is Oracle 8i). I
>have a simple select statement in which I'm concatenating the
>results:
>select name||','||address||','||phone||','||email
>
>However, my resulting lines look like the following:
>
>George Burns,123 Main St,2125551
>212,email_at_company.com
>
>Monty Burns,1223 Hwy 21,2125551
>224,email_at_company.com
>
>Is there anyways I can get them to appear like the following,
>all one line with no breaks between lines?
>
>George Burns,123 Main St,2125551212,email_at_company.com
>Monty Burns,1223 Hwy 21,2125551224,email_at_company.com
>
>Thanks...
>
>
>* Sent from RemarQ http://www.remarq.com The Internet's
 Discussion Network *
>The fastest and easiest way to search and participate in
 Usenet - Free!
>
>

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!