Hide and Show All Regions

The use of APEX Hide and Show regions has proven to be very popular within our application. Our users want to have access to a number of sections of information on a single page but they don’t always want to see it all at once. For example, our person summary screen shows information relating to an individual’s addresses, telephone numbers, relations, aliases and other information stored within the system. Users may just want to get some basic information relating to an individual or they may want to view everything at the same time. Instead of having to expand or contract each section individually, one of our development standards dictates that if a page has more than one Hide and Show region then it must also have Show All and Hide All buttons.

Read the rest of this entry »

Free Money! APEX-Themes.com Affiliate Program Launches

I recently announced the launch of APEX-Themes.com, my new joint business venture with my husband Steve. At APEX-Themes.com you can buy and instantly download high quality stock APEX themes. Our themes feature Interactive Report styling and unique designs very different to the dull themes that ship with APEX.

Following on from the website launch I’m very pleased to annouce that we have now launched the APEX-Themes.com affiliate program. Join our affiliate program and earn generous commission for promoting APEX-Themes.com on your website, blog, forum or anywhere else you like! Read the rest of this entry »

New Site for APEX Themes – APEX-Themes.com

After a lot of hard work, pain and a few arguments I’m very glad to announce that my husband, Steve and I have finally launched a new website selling APEX themes called APEX-Themes.com. I’ve never been very inspired by the themes that are provided as standard; these are great for demo’ing but when you spend time and effort developing a fancy APEX application you want it to stand out from the crowd.

Steve is an experienced graphic artist, but he also has a strong technical background having been a games developer then web designer. I’ve now spent over two and a half years focusing on Oracle APEX development, so between us we’ve not only developed some nice looking new themes, but we like to think they come with some unique selling points.

Read the rest of this entry »

Dynamic Report Regions Tutorial

Sometimes requirements are such that you can’t write a simple SELECT statement to return the information you want to see on a page. For example, you might want a report that displays dates in the first column, names across the top and the task each person is performing on that date as the content of the report. I’ve written a scheduling application that requires a report exactly like this, however, I don’t know the date range or the people that the end user is going to want to see information for.

In another case we have a number of tables that all have the same structure. These are code tables that are used for Select Lists throughout our Forms and APEX applications. These tables all have the same four columns: identifier, code, meaning and an in use flag. There are hundreds of these tables so I don’t want to have to write a separate page to see the data in each of these tables. Not only would this take a considerable amount of time, but I’m likely to go crazy with boredom half way through! Luckily there is an easy solution to both these problems: Dynamic Report Regions. Read the rest of this entry »

Dynamic HTML Generated From PL/SQL Tutorial

Using APEX it’s very easy to display information using forms and reports regions, you could even throw in a chart or dial for a bit of something different. However, it’s also simple to generate HTML pages from PL/SQL code. This opens up a world of choice when it comes to designing and developing your application.

This tutorial is a simple demonstration of creating HTML output from PL/SQL code. It assumes that you have completed the APEX_ITEM Tutorial as it relies on the checkbox and ticked column that you create within this tutorial. Read the rest of this entry »

Adding a Checkbox to Your Report – APEX_ITEM Tutorial

OK, so you’ve got a report, but you want something more. You want to add functionality to your report. You want to be able to tick things and have it do stuff. Luckily there’s an easy way and it’s called APEX_ITEM.

This tutorial will talk you through adding a checkbox to your report and adding functionality to your page to identify records that are ticked and processing them.

This tutorial assumes you have a workspace with the Sample Application installed.

Read the rest of this entry »

Oracle APEX Design Suggestions

No, I don’t need any help designing a database, or the Oracle Application Express screens. And I’m not even after ideas for a new application, thank you. What I’m after is some suggestions on how to create design specs for APEX applications and any standards that could be followed. As I’ve probably mentioned before, I work for a fairly large software house where traditionally we’ve only worked with Oracle Forms. We’ve just finished developing our first commercial APEX application and we’re about to start on our next one, which will be considerably bigger. Read the rest of this entry »


The interest in APEX is definitely growing and it’s obvious that Oracle has a lot of pride in it. There’s a great deal of APEX buzz at the Oracle events, such as the recent ODTUG08 where Dimiti Gielis, Patrick Wolf, John Scott and Scott Spendolini have all been involved in the excitement. However, some of us can’t simply jump on a plane and jet off to America to join in these events. Read the rest of this entry »

Changing the Login and Start Pages

Sometimes the simplest things make the biggest difference. Some users want to see a summary screen when they access an application, others want to get straight to business. If we can reduce the number of clicks required to get users to their desired page then we have happy customers. So how can you tailor your APEX application so that users aren’t just taken to Page 1 when they log in? And what if you don’t want to have page 101 as your login page? Read the rest of this entry »

Did I Miss the Memo? Where is the DHTML List Template?

Did you know the DHTML List (Image) with Submit template has been replaced by the Pull Down Menu with Image template? I’ve not checked all the themes, but certainly the ones we use no longer have this list template. Read the rest of this entry »