Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> SqlLoader and Concatenation of Comma separated values

SqlLoader and Concatenation of Comma separated values

From: TurkBear <noone_at_nowhere.com>
Date: Fri, 26 Jan 2001 10:32:39 -0600
Message-ID: <0d937tsaht71qifggtcqh8bv1sju1utf0o@4ax.com>

Hi,
I need to load a CSV data file into an Oracle table and the data file has separate fields for the date and time - Can I, without rewriting to use positional specifications, concatenate these 2 into 1 Oracle Date/Time field....?

Thanks,
( details:
Target Database is 8.1.6 ;
Will be using Oracle Bulk Loader , if possible, running on Solaris 2.7; Received on Fri Jan 26 2001 - 10:32:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US