SQL*Plus pads numeric data in query result
From: Bob Blizard <rblizard_at_bb.cmcsys.com>
Date: 1996/02/14
Message-ID: <4fuc5o$ih2_at_caesar.ultra.net>#1/1
Date: 1996/02/14
Message-ID: <4fuc5o$ih2_at_caesar.ultra.net>#1/1
I am trying to get a select in SQL*Plus (3.1.x) to produce a flat file
suitable for load using sqlload. The problem I am having is that no
matter what I try, I seem to get 4 spaces padding the left side of my
numeric data. I have tried most everything (except the right thing, of
course):
set heading off
set space 0
set pagesize 0
set numwidth (all sorts of values)
I have tried 'column deptno format 99' without success.
This is driving me slowly bonkers. Can anyone tell me the whatsit I have missed?
Please email, as this newsgroup is getting _too big_.
Thanks in advance.
Bob Blizard rblizard_at_cmcsys.com | All these worthwhile CMC Systems | opinions are mine, and175 Littleton Rd Westford, MA 01886 | not necessarily CMC's... Ph (508) 392-1300 Fax (508) 392-1303 | "If you want to park in the first row of life,
go there first to look." Received on Wed Feb 14 1996 - 00:00:00 CET