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: How can I get rid of carriage return?

Re: How can I get rid of carriage return?

From: Yosi Greenfield <yosi_at_newsalert.com>
Date: Fri, 22 Oct 1999 12:02:05 -0400
Message-ID: <38108A7D.365DDF07@newsalert.com>


If you mean in SQLPlus, try

    set linesize 1000
(or some number larger than the sum of the length of the columns display).

HTH Yosi

suisum_at_ecn.ab.ca wrote:

> Hi:
>
> How can I get rid of carriage return? I want the data in a very long line
> without any carriage return.
>
> e.g SELECT field_one from table;
>
> THe value of the field_one must be in a very long line.
>
> THanks,
Received on Fri Oct 22 1999 - 11:02:05 CDT

Original text of this message

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