Oracle Apex Data Load

2
votes

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.

1
sqloracleplsqloracle-apex

1 Answers

3
votes

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.