- This database was created with database character set AL32UTF8 (we're still a little confused by the Amazon Machine Images from Oracle aren't already AL32UTF8.
- The Websheets feature is now available. The security of Websheet applications still needs to be refined, but the functionality and ease of creation of these types of applications is amazing.
- The new tree region makes its debut.
- Collections now support NUMBER and DATE
- apex_collection.create_collection_from_query_b and apex_collection.create_collection_from_queryb2 support bind variables and row limits
- Debugging and logging has been completely rewritten - no longer is debug output emitted within the page, but it's collected and can be viewed later (and also queried via views).
- You won't be able to see this, but the tablespaces / data files of provisioned workspaces will now autoextend
- There have been many improvements in the Plug-In infrastructure, which Patrick will surely expand upon.
- A Migration Assistant has been created, which lets you upgrade all of the elements of your pre APEX 4.0 application in one place.
- Native validations and declarative validations have also been rewritten and improved (again, Patrick will expand upon this).
- All of the item types have been consolidated (so you no longer see 1,000 different Date Picker types in your item type select list, as well as other item types)
- A large number of bugs and usability issues have been corrected, thanks in a large part to the tremendous amount of feedback we received.
If you had used the first Application Express 4.0 Early Adopter instance, your workspace and schema have not been migrated to this instance. You will need to sign up for a workspace but you shouldn't have to take the survey again. The original Application Express 4.0 Early Adopter instance is available at http://18.104.22.168/apex, and it will be available for the next couple of weeks.
Thanks to everyone who has participated and provided feedback, as the feedback and suggestions have been invaluable.