DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: SQL LOader script

  1. #1
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349

    Arrow SQL LOader script

    Hi,
    I've arequirement of loading some data from csv file to a table. BUt at the same time i've to load the serial#. For example, in csv file i've emp_name,salary,designation as john, 8000, consultant. In table i need to load 1,john,8000,consultant. where 1 is serial# and it's autoincreamental. That means in next row it'll be 2,3,4....

    How can i do this. Any advice highly appreciated.

    Thanks
    http://www.perf-engg.com
    A performance engineering forum

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    use a sequence and call nextval

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Quote Originally Posted by davey23uk
    use a sequence and call nextval
    Or use SQL*Loader's own SEQUENCE generator (it might be faster than calling database's sequence NEXTVAL).
    http://download-west.oracle.com/docs...06.htm#1008321
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Jun 2005
    Location
    London, UK
    Posts
    159
    SQL*Loader - that's what we used to use before we had external tables, right?

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Quote Originally Posted by WilliamR
    SQL*Loader - that's what we used to use before we had external tables, right?
    ... and that's what we still use today when the source files are on client's machines, not on the database server.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

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


Click Here to Expand Forum to Full Width