Re: Getting all rows of sqlplus output on one line
- From: Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx>
- To: Rodd.Holman@xxxxxxxxx, "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- Date: Thu, 5 Oct 2006 14:17:31 -0700 (PDT)
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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts: