SQLLDR , Skipping fields
From: <pmohanan_at_my-deja.com>
Date: 2000/07/14
Message-ID: <8kn75f$d27$1_at_nnrp1.deja.com>#1/1
Date: 2000/07/14
Message-ID: <8kn75f$d27$1_at_nnrp1.deja.com>#1/1
[Quoted] Hi..All,
I am downloading the data from sybase to load into Oracle DB. Now, all the data fields in the data file are not required & its a variable [Quoted] length record. If the record looked like :
Field1|Field2|field3|field4|field5|field6|field7|field8
I want to pick only say, field1, field3, field7 & Field8. Is there any [Quoted] option in SQLLDR where I can specify which fields are needed.
- Positions won't work as its a variable length record.
Thanks a lot in Advance.
Regards,
Praveen Mohanan
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Jul 14 2000 - 00:00:00 CEST