Home » RDBMS Server » Server Utilities » Sqlldr: How to load select fields in a delimited file?
Sqlldr: How to load select fields in a delimited file? [message #70232] Tue, 07 May 2002 12:04 Go to next message
Raphi
Messages: 3
Registered: November 2001
Junior Member
How can I load predefined fields into an oracle Db from a '|' delimited file?

Report message to a moderator

Re: Sqlldr: How to load select fields in a delimited file? [message #70249 is a reply to message #70232] Mon, 13 May 2002 12:20 Go to previous message
Kari Ohlsen
Messages: 2
Registered: May 2002
Junior Member
Just place the word FILLER in the control file wherever there is a field you don't want to load.

e.g. (field1, field2, FILLER, field3)

Report message to a moderator

Previous Topic: Loading data from a .xls file using sql loader
Next Topic: SQL Loader - selective fields
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 01:27:10 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.