Oracle APEX Page Template Position Preview

On Friday I had to do some work on an Oracle Application Express (APEX) application of a client which I did some time ago. I had to create a new region next to an existing region on a page which had already several other regions on it. Normally no big problem, you would just use the “Column” property of the region and you are done. To make it short, it didn’t work because of the layout of the template and the existing regions which are already using the “Column” property.

Continue reading

Add Double Click to Oracle APEX Shuttle Widget

Do you want to improve the usability of the Oracle APEX Shuttle Widget a little bit?

Let’s enhance it by adding support for double click. It will allow users to double click on an entry in one of the two lists of the shuttle, to move the selected entry to the other list as they would normally do with the corresponding icons. I think that’s a little bit more convenient and faster than using the icons.

There comes the necessary code.
Continue reading

ApexGen: A new Oracle APEX related open source project!

Morten Braten just released this first Alpha Version of this new project called ApexGen – The Oracle APEX Generator. From the project description:

ApexGen is a utility to generate Oracle Application Express (Apex) pages and page components based on a PL/SQL API, in a fraction of the time it takes to manually create report and form pages.

I have downloaded the files and had a quick look at the documentation. Actually it’s a much nicer documentation than mine for the ApexLib Framework. Clean and very nice layout! To my rescue I can say that I already redid the layout for my Oracle APEX Builder Plugin project a few weeks ago, because I thought it needs better marketing. Just haven’t announced the new web-site yet. But back to the topic. :-)
Continue reading

"Comment out" an Oracle APEX Process, Validation, Branch, …

Sometimes during development there is the requirement to “Comment out” a Process, a Validation, … in an Oracle Application Express (APEX) application. To skip a step which doesn’t work anymore, or where a user says he doesn’t need that anymore but where you are sure that next week you are going to add it again…

In Oracle Forms that’s quite simple. You just have to rename the trigger to use underscores (eg. PRE-QUERY to PRE_QUERY) and the trigger doesn’t fire anymore. But how can you do that in Oracle APEX?

Continue reading

A "hidden" gem of Oracle Application Express

Oracle Application Express (APEX) has a “hidden” gem (ok, there are a lot of others too) which in my opinion isn’t widely used by the developers.

Be honest, how often do you use the little “View” select list on page definition?

You should, because it has several useful entries which can make your life easier! But let’s have a quick look at the different options.

Events

That’s a really useful feature for Oracle APEX beginners, because it shows you for the current page the flow of events when a page is processed or rendered. If you check the “View All” radio option it Continue reading