| field omission [message #73433] |
Mon, 26 April 2004 23:41  |
akif güngör
Messages: 4
Registered: April 2004
|
Junior Member |
|
|
i have this ascii file:
field1|field2|field3|field4
1020|CO|USA|LA
54132|AS|EUROPA|LONDRA
5464|NET|ASIA|ISTANBUL
my table
create table deneme
(
field1 NUMBER(10),
field4 VARCHAR2(10)
)
i want to insert only field1 and field4 to my table.
how do i must write control file.
thanks, sorry my english.
|
|
|
|
| Re: field omission [message #73446 is a reply to message #73433] |
Sat, 01 May 2004 20:46  |
 |
Barbara Boehmer
Messages: 9097
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
load data
infile 'deneme.dat'
replace
into table deneme
fields terminated by '|'
trailing nullcols
(field1,
field2 filler,
field3 filler,
field4)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
