read txt file and update into db [message #257890] |
Thu, 09 August 2007 07:39  |
bbvic
Messages: 24 Registered: October 2006
|
Junior Member |
|
|
testtext.txt format is like
id ( position 1 - 10), name(position 11-50), address (position 51-200), status(position 211-213)
after read the text file , and then it has to update name and status data to the oracle table.
SQL:
Update addresses set (username = 'name from text file', add_status='status')
Where exists (SELECT id FROM addresses s, address ad WHERE s.id = ad.id )
How to read the data and update the value into table?
|
|
|
|
|
|