Update multiple Rows in DB
I'm using APEX 4.1.0.00.32.
I have a Report with multiple rows and columns in the Application and a Table in a DB. Both have the same structure. Each row has a hidden Identifier
The User has to do changes /inserts in each of these cells.
Month1 Month2 Month3
System1 Val1 ___ Val5
System2 Val2 ___ ___
System3 ___ Val3 ___
With a Submit Button I want to write all the changes into the DB. Is there a way to update multiple rows in a DB-Table or does APEX just Support Updating 1 Row at one Time.
Maybe via PL/SQL Skript to catch the Submit Data /Data in the Fields and write them to DB with own Script? Or is there a more easy way to do it?