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: Return from function forces CR/LF ???

Re: Return from function forces CR/LF ???

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 28 Feb 2003 19:47:55 +0100
Message-ID: <rgbv5vcbvovki1i1f0o8d4785d6b5ucs0m@4ax.com>


On Fri, 28 Feb 2003 09:50:08 -0800, "Bill Rowland" <billrow_at_onemain.com> wrote:

>Any ideas how I can suppress the CR/LF in the output???

There is no CR/LF in the output. Your linesize parameter is insufficient forcing sql*plus to wrap.

You can resolve this by either
- put a
  column <column_name> format a<n>
  before the select, to reduce the width of the column - or
  use
  set linesize 132
  before the select

like this

SET COLSEP '|';
column order_flag format a32
set linesize 132
select product_number, part_number,

           (spi.is_orderable(part_number)) as order_flag from structure;

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Feb 28 2003 - 12:47:55 CST

Original text of this message

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