Insert Bulk Data in existing rows SQL

Question

I'm using Oracle's DB.I have a table say T. It has following columns id, att1,att2,att3. Now for a large amount of data att3 is blank. I've created a csv file which contains data in the format id,att3 it has a lot of data. How do I updatefrom this file to existing rows? Any way of doing it via pl/SQL

You'll first have to bulk load it into a new table (which you can drop afterwards). You can perform the update from there. — HoneyBadger
– HoneyBadger, Commented Jan 16, 2018 at 15:01
Can you clean up your questions, are you asking to INSERT rows or are you asking to UPDATE your question describes updating but asks to insert. — Andrew
– Andrew, Commented Jan 16, 2018 at 15:01
I meant how to update the existing rows! Thanks updated the questions — vishu
– vishu, Commented Jan 16, 2018 at 15:02
1: Create Table, 2: Bulk load csv data, 3: Update existing table, 4: Drop table created in step 1. — HoneyBadger
– HoneyBadger, Commented Jan 16, 2018 at 15:05

Esteban Garcia · Accepted Answer · 2018-01-16 15:02:16Z

0

Which database engine are you using? The answer might vary depending on that. But this post here How to update selected rows with values from a CSV file in Postgres? is similar to what you're asking, I'm sure you can adapt it to your needs.

answered Jan 16, 2018 at 15:02

Esteban Garcia

2,29317 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert Bulk Data in existing rows SQL

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related