It sounded like an April 1st joke as Kris Rice announced the release of the long awaited Oracle XE 11g Beta Version.
On OTN you can download either a Windows Installer or a Linux Installer (no mac version there).
Ever got a “ORA-01841: (full) year must be between -4713 and +9999, and not be 0” Error when trying to edit an existing user in APEX Administration Panel (Manage Workspaces > Manage Developers and Users) ?
When you create a Form page with the APEX Wizard it puts all the fields in just one column which can create a very long page.
This can reduce the use experience and usability a lot.
Sometimes it is a better way to put the fields in two (maybe three) columns and present them all on one screen. This gives the user the benefit of seeing all the information at once. Continue reading
A couple of days ago i got an emergency call from someone who attended my presentation at DOAG 2010 about APEX Translations.
Apparently they deleted (by accident) their APEX Translations (which reside in WWV_FLOW_TRANSLATABLE_TEXT$) and have neither a DB-Backup of this table nor a Backup of the XLIFF Files. Continue reading
One nagging thing about APEX occurs often to me. It’s the inability to customize the Workspace Login Page.
In APEX Instances within corporations you may want to display your own Logo or some custom text explaining your developers what to do and what not.
Just a quick note: When you are working with a multilingual/translated APEX Application you sometimes need to join LOV Values in your SELECT Statement.
Pretty basic and easy, but still i have a sticky note at my monitor which reminds me of what is what.
A typical APEX URL looks like this:
http://tryapexnow.com/apex/f?p=2500:1:1016153158259880
That means:
open Application 2500 on Page 1 using Session 1016153158259880
But there can be much more… Continue reading