-
Hi all!
query:
1.What is the insert command to be issued for sql*loader
and where is it to be used.
Regards,
Amitstora.
-
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
-
Insert is a default in sql*loader,
exp
load data
infile *
into table emp
(this line means => insert into table emp )
Jani
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|