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 -> SQL*PLUS Format Question

SQL*PLUS Format Question

From: Andy Hering <andy_hering_at_forecross.com>
Date: 1998/06/02
Message-ID: <35747512.84260F30@forecross.com>#1/1

Hi,

 I'm using a sqlplus script that will dump the contents of a table into an ASCII Flatfile. Everything works fine, except that the first column does NOT start at position one, but rather position 2. I tried several ways to resolve this, but nothing seemed to work. When I tried ltrim, it forced the column in position 1, but put a lot of spaces between column 1 and column2. My first column is a number column. Is there any way to get the SQL*Plus to start the output at position 1?

Thanks,
Andy Received on Tue Jun 02 1998 - 00:00:00 CDT

Original text of this message

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