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.

Report message to a moderator

Previous Topic: another simple sql loader question
Next Topic: Re: SQL*LDR - filenames containing spaces (WinNT)???
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 02 23:18:51 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.