Re: SQL*Loader 2 fields->1 field

From: Amit Aggarwal <amaggarwal_at_kendle.com>
Date: 1997/09/29
Message-ID: <34301E9F.76A1@kendle.com>#1/1

Vincent Chang wrote:
>
> Hi, Everybody
> I am using SQL*Loader to load a flat text file data. I need to load
> 2 fields (time and date) into 1 field in table (oracle datatype 'date'
> can hold these 2 info in 1 field). Any suggestion for this problem?
> Thanks.
>
> vincent

An easier way may be to combine the two fields in the flat file, e.g. using awk or some other tool, and then using SQL*Loader to load the table.

amit
Oracle DBA/Unix SA Received on Mon Sep 29 1997 - 00:00:00 CDT