0

I have a .csv file, which contains id & name. I want to update the names in a database table based upon the id. I'm not sure whats the best way to achieve this. I think it can be done through stored procedures but i'm not sure how i could accomplish it. ANy references or code would be appreciated.

Improve this question
7
  • You can use a java code to insert. Let me know if you want code samples Commented Jun 3, 2014 at 11:44
  • There are 2 separate systems, hence, we would have to get data through a text file. Java code would require production deployment first, which is what I'm trying to avoid. Commented Jun 3, 2014 at 11:47
  • @Aazim Why don't you use SQL*Loader? Commented Jun 3, 2014 at 11:51
  • Yes, i read about it. But isn't SQL Loader used to insert data in the database . I can't use it for update. Commented Jun 3, 2014 at 11:56
  • @Aazim Yes you are right, SQL Loader is for inserts, not updates. Having said this what you could do is create a temporary table and insert data into this table and then run an update statement with newly created table based on id. Commented Jun 3, 2014 at 12:01
Related questions
8
Update Oracle table with values from CSV file
0
How to update/Edit table through CSVs?
0
Bulk Update in Oracle from CSV file
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.