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: SELECTing multiple rows to a single output line

Re: SELECTing multiple rows to a single output line

From: R. P. <r_pol12gar_at_hotmail.com>
Date: Sun, 21 Aug 2005 19:30:33 -0700
Message-ID: <grKdnV9tJOBVpZTeRVn-2w@comcast.com>


"Barbara Boehmer" <baboehme_at_hotmail.com> wrote:
> If your concern is just running out of space on a line and you don't
> need the widget name repeated on each line and you are executing from
> SQL*Plus, then you can just add a space after each comma and use SET
> COLUMN ... FORMAT ... WORD_WRAPPED. I have provided an example of
> that
> below and below that I have provided exactly what you asked for, with
> the widget name repeated, with syntax that does not require SQL*Plus.

Thanks once again, Barbara, for your invaluable help. This should do what I am after.

Rudy Received on Sun Aug 21 2005 - 21:30:33 CDT

Original text of this message

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