SQL Loader [message #70567] |
Mon, 01 July 2002 10:08 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sonia
Messages: 22 Registered: March 2001
|
Junior Member |
|
|
I'm trying to do both a truncate and insert into a table. CAn someone show me the syntax for the control file to do this.
Thanks
|
|
|
|
Re: SQL Loader [message #70570 is a reply to message #70567] |
Mon, 01 July 2002 13:02 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/42800.jpg) |
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
i beleive the same syntax will do that.
first it will truncate the table and insertst the data
LOAD DATA
INFILE *
TRUNCATE
INTO TABLE xxx_Table_name
...
...
|
|
|