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.
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.
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.
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?
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.
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
Did you know that you can use the keyboard shortcut Ctrl+Return in the SQL Commands textarea of the Oracle APEX SQL Workshop application to execute the current SQL statement?
That’s really nice, especially if you are used to it from PL/SQL Developer/TOAD.
Yesterday I came across Graphviz and remembered that a college had already used it to generate some ERDs/Class diagrams. After taking a closer look, I thought to give it a try and use it to generate a page flow diagram for an APEX application as you can also see it for JSF in JDeveloper.
If you are using Firefox for your APEX development you may want to check out my list of add-ons I’m currently using for the web development. If you have any useful add-ons you are using, drop me a note!
If yes, continue reading. If not, continue doing it again and again, … 😉
For example you like the “Standard, Alternating Row Colors” template for reports or you don’t want to write help texts (which developer does?) for your items, but the Oracle APEX builder always defaults the item to “Optional Label with Help”.