On Thursday, 3 February 2000 at 13:30:00 UTC+5:30, Connor McDonald wrote:
Steve Haynes wrote:
In article <8781ar$n2...@usilws15.ca-nethaven.com>, Tim Cope <cop...@cai.com> writes
You can specify the column as a FILLER and sqlldr will skip that column. >For example:
INTO TABLE MYTEST
(
col1 CHAR(20),
col2 FILLER CHAR(30),
col3 CHAR(20)
)
New one on me, what version did this arrive in?,
I'm sure it didn't used to be possible.
Steve
Available in 8i.
Typically people use "cut" or equivalent in Unix as a pre-process to do
the same in lower versions.
HTH
--
===========================================
Connor McDonald
"These views mine, no-one elses etc etc"
connor_...@yahoo.com
"Some days you're the pigeon, and some days you're the statue."
Hi,
Can we skip the field names in CTL file?
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)