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

Thread: Sql*loader insert command!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    Hi all!

    query:

    1.What is the insert command to be issued for sql*loader
    and where is it to be used.

    Regards,

    Amitstora.

  2. #2
    Join Date
    Aug 2001
    Location
    Hyderabad, India
    Posts
    29

    Question

    First of all I didn't get you question
    Using SqlLdr program you can load the in to the database using control file.
    Venkateshwarlu.K

  3. #3
    Join Date
    Aug 2001
    Posts
    134

    Insert is a default in sql*loader,
    exp
    load data
    infile *
    into table emp
    (this line means => insert into table emp )

    Jani

  4. #4
    Join Date
    Jul 2000
    Location
    Amsterdam
    Posts
    234

    sqlldr question

    Hi amitstora,

    There are three modes of loading data in a table replace, append and insert.
    When creating your control file for sqlldr (.ctl file) you can choose only one off them.
    Append => excisting data stays in table new data is loaded on top
    Replace => table is truncated and new data is loaded
    insert => data can only be loaded when table is epmty

    HTH

    tycho


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