Re: Getting all rows of sqlplus output on one line

From: Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
Date: Thu, 5 Oct 2006 14:17:31 -0700 (PDT)
Message-ID: <20061005211731.97158.qmail@web52808.mail.yahoo.com>

I am using something on the same lines for a sql_text column that has CR/LF in it:

replace(substr(sql_text,1,124),chr(13) || chr(10),' ') sqltext

Does this help?

Deepak

• Rodd Holman <Rodd.Holman_at_gmail.com> wrote:

> 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.
>

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 05 2006 - 16:17:31 CDT