Home » RDBMS Server » Server Utilities » sql loader question
sql loader question [message #365532] Thu, 24 September 1998 09:49
Kevin Rose
Messages: 6
Registered: September 1998
Junior Member
Im trying to load a flatfile and merge several columns to make a date field. The file looks like this:

columns field
17-18 year
19-20 other data
20-30 other data
31-32 month
33-34 day

I would like to merge the year month and day to make one ORACLE DATE type. Can anyone provide the sql loader code to help me with this.
Previous Topic: another simple sql loader question
Next Topic: Re: SQL*LDR - filenames containing spaces (WinNT)???
Goto Forum:
  


Current Time: Thu May 19 16:35:30 CDT 2022