help sql*loader

[sonukhan]

I have 10 flat files in single folder ,so by using one control file how we transfer all 10 files data in single table.

[siva sankar]

Hi,

Please try this one...

LOAD DATA
INFILE ?C:\FIRST.DAT?
INFILE ?C:\SECOND.DAT?
INSERT INTO TABLE FIXED_EMP
FIELDES TERMINATED BY ?,?
(EMPNO, ENAME, DEPTNO)

if any queries please let me know.

[antojoen]

Hi,

Use a loop to execute this.

Take a count *.DAT files and execute the .CTL files that many times. Dont hardcode the *.DAT file name into the control files. That should be dynamic.