Home » RDBMS Server » Server Administration » How do i cut colums in a space delimited data file
How do i cut colums in a space delimited data file [message #57299] Tue, 03 June 2003 09:10 Go to next message
sidd
Messages: 130
Registered: May 2003
Senior Member
How do i cut colums in a space delimited data file, what commands does this

Report message to a moderator

Re: How do i cut colums in a space delimited data file [message #57303 is a reply to message #57299] Wed, 04 June 2003 07:52 Go to previous messageGo to next message
Sascha
Messages: 15
Registered: November 2002
Junior Member
With SQL Loader you can use the FILLER command.
(8i or above)

check this out: http://www.orafaq.org/faqloadr.htm

Report message to a moderator

Re: How do i cut colums in a space delimited data file [message #57324 is a reply to message #57303] Thu, 05 June 2003 17:32 Go to previous message
Guy Rassabi
Messages: 10
Registered: February 2003
Junior Member
You can also use the substr() function in the CTL file beside that column...

Guy

Report message to a moderator

Previous Topic: User processes running in oracle
Next Topic: multiline load
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 08:14:19 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.