Results 1 to 2 of 2

Thread: sql loader

  1. #1
    Join Date
    Feb 2007
    Posts
    1

    Unanswered: sql loader

    How to upload data using variable tablename in sql loader control file?

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I wouldn't know.

    But, you might always load records into an "intermediate" table and later, using (PL/)SQL transfer data from that table to another one (a procedure with table name as a parameter might be one way to do it).

    Or, if your database version supports it, use external tables feature. File you have would then be an "external table", and the rest of the story would be the same as in a previous case.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •