0

The contents of the CSV file is as shown: 

LOAD DATE,30-Nov-15
STORE,MANAGER NAME,PHONE Number  
519900,STEVEN FRENCH,905-271-3644  
520300,IAN MCGAUGHEY,519-672-9986  
512400,,416-665-4657  
512900,RAKESH PRASAD,905-672-6301

I want to add 30-Nov-15 to a column of table1 and

519900,STEVEN FRENCH,905-271-3644  
520300,IAN MCGAUGHEY,519-672-9986  
512400,,416-665-4657  
512900,RAKESH PRASAD,905-672-6301

to 3 columns of table2 using a single CTL file. Please help.

Delwin Noronha
  • 1
  • 1
  • Are there any other columns in your `table1` apart from the `load date`? – Kaushik Nayak Sep 01 '17 at 16:13
  • yes there are other columns too. They need to be filled with constant values. – Delwin Noronha Sep 01 '17 at 17:22
  • SQL\*Loader does have syntax for inserting into multiple tables but it requires the rows to have some indicator to distinguish the rows. It is a utility for loading data in a format which has been designed for it. If you want to load some randomly structured CSV fie you need a programmatic solution. Either some external code to pre-process the file, or some PL/SQL or external table solution. – APC Sep 06 '17 at 06:34

0 Answers0