Home » RDBMS Server » Server Utilities » Using SQL*Loader on flat file without delimiter
Using SQL*Loader on flat file without delimiter [message #115122] Thu, 07 April 2005 11:25 Go to next message
joelny
Messages: 4
Registered: April 2005
Junior Member
Hi,

I've read many articles about SQL*Loader but they all mentioned about delimiters...does SQL*Loader work with flat files without delimiters too?

I have a flat file without delimiters. I only have character positions on where each field starts and ends. Is SQL*Loader still feasible in this case?

Thank you very much!
Re: Using SQL*Loader on flat file without delimiter [message #115130 is a reply to message #115122] Thu, 07 April 2005 12:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch10.htm#1006795
Re: Using SQL*Loader on flat file without delimiter [message #115531 is a reply to message #115122] Tue, 12 April 2005 09:07 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
I like your answer Mahesh.
Previous Topic: Loading packed decimal data into date column?
Next Topic: Concatenate fields in sql loader
Goto Forum:
  


Current Time: Wed Jul 03 08:17:43 CDT 2024