Author Archives

Follow-up on comparing two Oracle schemas

Over 4 years ago I wrote a blog post about software that helps you to compare two Oracle schemas. That post is accessed a lot and I still get questions about it, so I decided to write a follow up on that post as things change over time.Comparing two …

APEX 4.0.1 Patch released

Hi just read Joel Kallman’s post that the Oracle Application Express (APEX) team released 4.0.1 which corrects a number of issues found in APEX 4.0.I recommend going to 4.0.1 if you have 4.0 installed as soon as possible.If you still have 3.x running a…

Add Default to Tabular Form in APEX

If you want to set a default value for a column in your tabular form, you can set the Default Type to “PL/SQL Expression or Function” and put into Default e.g. ‘N’.That sets the default for that column to the static text ‘N’.

Upgrade to APEX 4.0 – Known Issues – Workarounds and Patches

If you upgrade your application from APEX 3.x to 4.0 you might encounter some issues.At ODTUG I did a live migration of an application written in APEX 3.2 to 4.0 and I talked about some of the issues I discovered and how I worked around them. I’m doing…

APEX Father is speaking …

If you didn’t pickup another important APEX blog to follow yet… you definitely want to follow Mike Hichwa.Mike is the “father” of APEX, it must be over 10 years ago he started with the development of APEX (HTMLDB/Project Flows).Mike is a VP at Oracle…

ODTUG comes to Europe in October! Registration open!

As announced on the latest OBUG APEX SIG, we will participate in the first ever ODTUG event in Europe!It’s a two day conference focused on PL/SQL and APEX, with two full tracks for each.If you look at the Agenda you will see the presenters are well kno…