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

Home -> Community -> Usenet -> c.d.o.server -> storing Infile name into a column from SQL Loader

storing Infile name into a column from SQL Loader

From: R.Venkat <rvenkat_at_gmail.com>
Date: 21 May 2004 02:23:39 -0700
Message-ID: <31a9bd82.0405210123.7a2f94b@posting.google.com>


Hi,

   i have a requirement that i need to load data of the same format from different datafiles. now to distinguish between these records,i need to put the infile name also into a column named FILENAME in the target table. how do i do that?
Thanks,
~Venkat Received on Fri May 21 2004 - 04:23:39 CDT

Original text of this message

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