Hello Guys, so here is the story.
I had a meeting with one of my development team, they said they needed a way to insert data into oracle table from excel data sheet. So I did a bit of googling and found out that sqldeveloper & toad have in built application that would facilitate the data transfer from excel data sheet into oracle table.
When I presented this solution to the development team, they rejected this idea saying this is not what they are looking for. Then they said, they need an application where in, as the data is being entered into the excel sheet, the data should simultaneously be entered into the oracle table.
they don't want to load the data into the oracle table once all the data is finished entered into the excel table, they want the data to be dynamically entered into an oracle table as the excel sheet is being populated.
Did you guys come across any such application or tool that does this? or any ideas on how to satisfy my developer's requirements is very very helpful.
Thank You