|
|
|
|
|
Re: How to accept dynamic file name (file name format : FN_DDMMYYYY.DAT )for SQL Loader ? [message #281981 is a reply to message #281970] |
Tue, 20 November 2007 04:23 |
tapaskmanna
Messages: 98 Registered: January 2007 Location: Cyprus,Nicosia
|
Member |
|
|
Can we write a hard coded value in Control File i.e Fixed value
like "22032007" in below contol script to be uploaded in the stage table?
Control File
-----------------------------------------------------
load data
infile '\data\FN_22032007.csv'
into table emp
fields terminated by "," optionally enclosed by '"
(empno, empname, sal, deptno,"22032007" )
----------------------------------------------------------
|
|
|
|
|