3 Replies Latest reply: Nov 25, 2012 12:29 PM by 865659 RSS

    Sql loader

    862489
      In SQL Loader,

      I would like to get the INFILE used in control file to be loaded as a column in the target table to be loaded ? Is it possible to do it in SQL Loader?

      Any suggestions?

      thanks
        • 1. Re: Sql loader
          Karthick_Arp
          [url http://www.oracle-base.com/articles/10g/load-lob-data-using-sql-loader.php] Loading LOB Data using SQL * Loader
          • 2. Re: Sql loader
            rp0428
            >
            I would like to get the INFILE used in control file to be loaded as a column in the target table to be loaded ? Is it possible to do it in SQL Loader?
            >
            No - there is no way to reference the value that was specified as INFILE. Even if you could it would get loaded into every row.
            • 3. Re: Sql loader
              865659
              I have the requirement to load the file name of data file(csv) as a column in my staging table.
              How to achieve this using control file?

              Plz reply asap.