If this question has been raised before, apologies, I did try to search but could find what I was looking for.
I'm a new user of SQL Developer, and have a question around updating a table using an excel spreadsheet.
I've come across from using Toad which has an Add/Append or Update options as part of the import wizard
It's an extremely useful tool/option when mass updating data into a table.
The process matches primary keys and will update matched records on the columns provided.
I cannot find a same/similar options / process for SQL Developer
Is there such a thing?
If not how do I go about completing a mass update of records via an Excel spreadhseet?
Thanks everyone