Steve Haynes wrote:Hi,
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?,Available in 8i.
I'm sure it didn't used to be possible.
Steve
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."
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 296 |
Nodes: | 16 (3 / 13) |
Uptime: | 49:44:08 |
Calls: | 6,649 |
Calls today: | 1 |
Files: | 12,200 |
Messages: | 5,330,189 |