Oracle Application Express (MOSC)

MOSC Banner

Update multiple Rows in DB

edited Dec 6, 2012 3:51AM in Oracle Application Express (MOSC) 6 commentsAnswered ✓
Hello,

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center