Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Update table wizard (Excel)

clackerzOct 9 2018 — edited Oct 10 2018

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

Comments

Mike Kutz

TAG using JSON value might be more flexible.

This would then allow template based code generators (eg ) to automatically identify which tables need to be combined together to create a specific Transactional API (XAPI).  (eg an API that must work with >1 tables)

MK

1 person found this helpful
Jeffrey Kemp

Tags for table columns, constraints, etc. would also be useful.

1 person found this helpful
Matheus Boesing

TAG using JSON value might be more flexible.

This would then allow template based code generators (eg ) to automatically identify which tables need to be combined together to create a specific Transactional API (XAPI).  (eg an API that must work with >1 tables)

MK

Great Mike!
It really should be done with JSON syntax. It allows to create different kinds of tags in a single 'tag column', like:
[...]TAGS ('{Use:Transactional, SensitiveData:false, Version1.0:MatheusDBA, Version2.0:AnotherDBA}');


Or even tags hierarchies/subtypes... Anyway, it's way more flexible.
Thanks for this insight!

Matheus Boesing

Tags for table columns, constraints, etc. would also be useful.

Exactly... I just used some kind of objects for this example... but I believe it can apply for any king of object, including schemas... like (using Mike's contribution):
CREATE USER USER_EXAMPLE TAGS ('{Use:AdHocReports, Accountable:InternalBusinessTeam}');

Gbenga Ajakaye

This would definitely be useful.

1 - 5

Post Details

Added on Oct 9 2018
#database, #excel, #sql-developer, #table, #update
9 comments
2,884 views