| SQL Loader [message #70567] |
Mon, 01 July 2002 10:08  |
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  |
 |
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
...
...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
