Oracle query help - JDBC

Question

I have two tables. I need to fetch data from one table and insert it into the other table, provided the data (say ID) does not exist in the second table. If the data exists, I need to update the values in the table for that id.

How can we achieve that?

I first collect all data from the first table in an arraylist, and iterate through the list. If the element presents in the second table, I call the update query. If not, I call the insert query.

Any other way to achieve this? I think it takes so much time, even though its straightforward.

PS: I dont have my query with me now

If both tables are same, you can truncate all the rows in 2nd table and run a single insert query from 1st table. — vels4j
– vels4j, Commented Jan 17, 2013 at 17:38

Plouf · Accepted Answer · 2013-01-17 17:46:10Z

1

Look at the MERGE statement. This is what you are looking for: MERGE WHEN EXISTS THEN UPDATE NOT EXISTS THEN INSERT (This is not the syntax)

answered Jan 17, 2013 at 17:46

Plouf

6373 silver badges7 bronze badges

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

Collectives™ on Stack Overflow

Oracle query help - JDBC

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related