Now APEX has great features with the new 4.1 version. My favourite new functionalities are
– No more Primary Key needs for Tabular forms for update and delete operations. ROWID usage is avaliable now. But it has a little bug now. You should manually add APEX$ROWID as alias to ROWID column.
"YEAR_MONTH" FROM MYTABLE
– Uploading data from excell or copy paste function is opened to end users. Thats great! Now end-users can upload their data from excell into a table defined by developer. Thats what makes life easier for end-users.
Oracle Application Express 4.1
Oracle Application Express 4.1 will focus on enhancement to existing functionality and additional capabilities to support applications running on mobile devices. Application Express 4.1 is planned to incorporate the following:
Development for Mobile Applications – Include themes and HTML templates suitable for smart phones and mobile devices.
Error Handling – Improve error handling and user-defined exception processing.
Tabular Forms – Continue to expand tabular forms validations.
Dynamic Actions – Allow dynamic actions to be defined for buttons and enhanced conditional processing.
Plug-Ins – Add plug-in support for additional components and enhance plug-in definitions.
Use of ROWID – Allow usage of ROWID for Automatic DML processing (as an alternative to identifying the PK columns).
Websheets – Improved user interface, new page section types, and enhanced spreadsheet / datagrid integration.
Data Upload – Enable end-users to upload data into an existing table (within an application).
Accessibility – Improve accessibility in existing themes and HTML templates.
Numerous functional and performance improvements.