Forum Stats

  • 3,768,181 Users
  • 2,252,755 Discussions


SQL LOADER with less fields in data file.

User_CS62G Member Posts: 17 Red Ribbon


I have a scenario to implement where in I have 10 columns in a table which has to be loaded in APPEND mode, i.e. the table already has records and we have to insert new records into it.

In data file we are only getting 8 columns data as the first 2 columns which are NOT NULL will contain constant values as 'CONS' & SYSDATE for every record to be inserted. Data file contains data from 3 column.

Now the requirement is to generate the control file dynamically and using the control file generated and data file load the data using sql loader.

For example :

Data file :


Record Inserted in table should be like :

Please suggest how to generate the control file dynamically which will help in loading 'CONS' for 1st column & SYSDATE for 2nd column and rest of the columns should be loaded as per the data available in data file.

Thanks & Regards,

Biswajeet Ghosh