Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Getting all rows of sqlplus output on one line
Rodd,
If SQL*Plus wraps the screen output (with the my solution), then - increase "linesize" in SQL*Plus.
Igor
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rodd Holman
Sent: Thursday, October 05, 2006 3:04 PM
To: Baumgartel, Paul
Cc: oracle-l_at_freelists.org
Subject: Re: Getting all rows of sqlplus output on one line
Same result there.
It's a DOS/Windows thing actually.
The CRLF ending in ascii text actually was a MSDOS construct that has
carried into Windows.
What I'm trying to figure out is there a way to make Windows sqlplus/sqlplusw output in UNIX format?
set record_sep ;
or
define _record_sep ;
or anything like that.
Others are sending me some pl/sql and type functions that I'm trying, but the result is the same. If sqlplus wraps the screen output when you copy that to the Business Objects field it truncates everything after the first line (it appears sqlplus us using CRLF as a line wrapper)
Most of this, as frustrating as it is, just confirms my decision to operate on a LINUX desktop and tell Bill where to put it.
Baumgartel, Paul wrote:
> Rodd,
>
> Have you tried running sqlplus from a DOS prompt, instead of sqlplusw?
You can copy any arbitrary region to the clipboard. It's easiest if you
click the upper-left-hand corner of the DOS window, select Properties,
and then check QuickEdit mode, in which clicking and dragging selects,
and right-clicking copies.
>
> Paul Baumgartel
> CREDIT SUISSE
> Information Technology
> DBA & Admin - NY, KIGA 1
> 11 Madison Avenue
> New York, NY 10010
> USA
> Phone 212.538.1143
> paul.baumgartel_at_credit-suisse.com
> www.credit-suisse.com
>
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Rodd Holman
> Sent: Thursday, October 05, 2006 1:45 PM
> To: oracle-l_at_freelists.org
> Subject: Getting all rows of sqlplus output on one line
>
>
> OK, I've been searching the docs (docs.oracle.com) and trying to
> figure out how to make this work from sqlplusw.exe. I'll let it be
> known from the first that I despise Windows and hate working in it.
Here's the case:
> We have Business Objects as a reporting tool. One of our power users
> wants to be able to enter in a list of site_id's into one of the
> parameter fields. Current selection capability is *ALL* or individual
> site_id. However, the tool lets you paste a ";" separated list into
it.
>
> Running the following
> select site_id||';'
> from site_list_table
> where definition_id in (nnnn, nnn2, nnn3) order by site_id;
>
> returns (as expected)
> site_id||';'
> ------------
> 0000100;
> 0000102;
> ...
> and so on.
>
>>From the UNIX/LINUX side I can select this list and paste it directly
>>From the windows side it only pastes the first value because sqlplusw
> me to re-write it each time the list changed. I don't want to get
> that involved with this user.
>
> I really hate Windows!!!
>
> Thanks
>
> Rodd
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
> ======================================================================
> ======== Please access the attached hyperlink for an important
> electronic communications disclaimer:
>
> http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
> ======================================================================
> ========
>
>
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 05 2006 - 15:17:31 CDT