CODEWITHSUNDEEP
sqloracle-databaseplsqloracle-apex
tako_tokyo
tako_tokyo

Reputation: 79

Oracle Apex Data Load

After creating some pages using Apex 5.1's Data Load Wizard, would it be possible via the Page Designer to somewhere hack into the data and add in 2 extra column data. I am attempting to add the following columns (1) Updater (2) Update date/time. I was able to do the same thing with an Interactive Grid page by adding PL/SQL code to the 'Save' Page Processing section but could not do the same for the Data Load Pages.

I have a five attribute table, 2 of which (Updater, Update date/time) are hidden to the APEX app user.

Upvotes: 2

Views: 1205

Answers (1)

Jeffrey Kemp
Jeffrey Kemp

Reputation: 60262

One option is to use a Data Load Transformation Rule. You can add this by editing the Data Load Definition via Shared Components. You specify the column, and you can specify a Rule Type of PLSQL Expression and set the expression to whatever you want, e.g. SYSDATE.

Another option is to add a trigger to the table to set those columns.

Upvotes: 3

Related Questions