1 Reply Latest reply on Oct 5, 2017 4:07 AM by Kanda-Oracle

    Oracle SQL * Loader / External Table data load

    2899825

      Hi,

       

      I have 2 columns and 9 rows, I can write control file to load data into one temp table.

       

      Is there a way 2 rows and 9 columns.

       

      below is the example.

      Legacy Data file .csv

      Header 1Header 2
      a10
      b20
      c30
      d40

       

      temp table

       

      demo is the table name and column names are (a,b,c,d)

       

      Header 1Header 2Header 3Header 4
      abcd
      10203040

       

       

      Please let me know is there any way to insert 2*4 into 4*2 table using data loader control file / External table.

       

      Thanks,

      Sudarsana