CODEWITHSUNDEEP
oracle-databasegoogle-apps-scriptoracle-apex
user1787288
user1787288

Reputation: 19

Insert or Update Data in Google Spreadsheet from Oracle Database

I would like to know how I can insert or update data in a Google Spreadsheet from an Oracle Database please?

Upvotes: 1

Views: 2184

Answers (1)

Waqar Ahmad
Waqar Ahmad

Reputation: 3730

Apps Script residing in a spreadsheet container or somewhere else can fetch data from oracle and update your spreadsheet but I don't think there is any simple way to update spreadsheet from Oracle side. For programming, Oracle uses PLSQL but I have not come to any solution yet to use Spreadsheet API with PLSQL.

It would be better to write Apps Script code and which will run by a time driven trigger and look for changes in Oracle table and update the same in spreadsheet. Here is the reference link to use JDBC Service in Apps Script.

Upvotes: 2

Related Questions