Dimitri Gielis Blog (Oracle Application Express - APEX)

Using Keystrokes in a Web Application

2009-08-13T23:39:00.005+02:00

There was an interesting question in the APEX Forum of somebody wanting to use the keyboard to control the screen.

Controlling your screen with the keyboard is a challenge when you are in a web environment as you can be on different platforms and have different browsers that are not always acting the same way.

I created a quick APEX page and included some javascript to enable that page to know what keys are typed from the keyboard. During testing I thought about what would happen with a text item and you want to type something in there... you don't want that something happens then (e.g. submitting the page when you hit S). Luckily in javascript you can control that as well.



<script type="text/javascript">
function checkKeyPress(evt) {
  // get events
  var evt = (evt) ? evt : ((event) ? event : null);
  if (!evt) return true;
  // get where you are on the page
  var node = (evt.target) ? evt.target : ((evt.srcElement) ? evt.srcElement : null);
  // if you are in a text item show this alert otherwise another
  if (node.type == "text") 
     alert('in item:' + evt.keyCode + ': ' + String.fromCharCode(evt.keyCode));
  else
     alert(evt.keyCode + ': ' + String.fromCharCode(evt.keyCode));
}

// on every Key Down, run the function to check which key was hit
document.onkeydown = checkKeyPress;

</script>

Interview in Oracle Magazine

2009-08-17T23:22:00.002+02:00

In the September/October edition of Oracle Magazine you find a part of the interview I had with one of the writers. I had to answer some questions and then the magazine selected three of them. You find it in the Peer-to-Peer section.

You can subscribe for free for the Oracle Magazine. I always enjoy reading the articles especially the ones of Tom Kyte, Sue Harper, David Peake and Steven Feuerstein.

APEX for Sales People

2009-08-17T23:09:00.000+02:00

You, as a developer, are really convinced about Oracle Application Express (APEX) but that is not enough...

If your company doesn't follow you, or you don't have projects, you can't really do APEX projects right?

The problem is that you need to convince your manager, the sales guy or your customer in another way.
But the typical arguments why to use APEX, in a developer points of view are not the same as what they want to hear!

Most of the conversations by Sales guys or managers are about costs (decreasing IT costs/budgets), increasing margin and revenue, doing more with less people and to get the solution for a given problem in a fast way.
(And if it wasn't difficult enough you might be in front of not only a manager but also an IT person who's not that open for a change ;-))

One of our client's problem for ex. is how to react more quickly to business needs? That is a valid question no? What if the business wants to launch a new campaign but the software/IT organization is not ready for it yet? In a typical waterfall model type of project it can take several weeks or months to get a solution. Maybe a RAD-tool might be a good fit in that case. Especially if you work in modules or an Agile way where you have more releases, more often.

It's not easy to speak those people's language if you are not used to it. I also think it depends the person you have in front of you, as some are more open for new ideas than others. I can't really give you a bullet point of "If he says this Than say that" (although I'm sure some sales people got such training), but I'm convinced that if you can help the people in front of you to full-fill THEIR goals and you speak with confident about your ideas, you already made a good start.

It depends a bit the customer, but in a lot of the cases APEX can decrease costs and get a solution faster which enables them to get more revenue. A demo is in most of the time also a good way of proving your word. But always remember it's not always the cheapest solution that is the best at the end.

There's a Solution Kit for APEX available that can help you to convince other people too.

European APEX Training Days back in Belgium

2009-08-25T10:28:00.007+02:00

Two years after our first "European APEX Training Days" we are coming back to Belgium to do another one. This one will be held in Leuven (the town I live in) from 26th till 28th of October 2009.

The format will remain the same; 3 days immersed in APEX with all APEX minded people and taught by two of the best known advocates of Oracle Application Express :-)

We have new topics for these training days and hope that next to the things you'll learn, you'll also have fun and feel the passion for APEX like we do.

Our Agenda (*) looks like this:

Monday

Best Practices
Working with Tabular Forms & Collections
Real World Apex Dictionary Uses
Webservice Integration

Tuesday

Javascript, AJAX & JQuery
Hands-on AJAX & JQuery
Mastering Charts and Gantts
Debugging APEX Applications

Wednesday

Themes & Templates
Hands-on Themes & Templates
Writing Secure Applications
Error Management

(*) We reserve the right to change content. In the event of any changes you will be given advance notice where possible.

Next to the predefined topics we are also available to answer all your other APEX questions at breaks and after hours. As before, on the second day we also planned something fun!

You can register for the training here.

Hope to see you in October,
Dimitri

APEX 3.2.1 Patch set available - Free Gantts and Maps

2009-08-26T10:09:00.002+02:00

Oracle released APEX 3.2.1 patch set. You can download it from the APEX website.

It will do a lot of fixes as you can read in the patch set notes, some of my favorites are:

Unable to use greater than character (>) in expression in CASE statement of computed column.
Unable to import SQL script using SQL Workshop, SQL Scripts, Import utility.
Degraded performance using interactive reports over time.

But another good reason for you to upgrade is because you get AnyGantt and AnyMap for free with it. Until APEX 4.0 comes out you need to write the xml yourself to generate the chart.
I've already some examples about Gantts and Maps on our Anychart Integration Kit website, but I'm working on releasing some more.

Extend your charts with Google Visualization Charts

2009-08-31T16:05:00.005+02:00

As already a lot of you know, I'm a heavy supporter of the Anychart charting engine, but there are other nice charting solutions as well...

A few weeks ago a customer of us requested a chart which you can replay. My first thought was "hmm that can be tricky", because I didn't know a standard feature of Anychart to do that. I could think about an AJAX solution where we refresh the chart so you could have kind of replay in time of your chart. When we asked the customer the exact requirements he pointed us to Google Visualization and the Motion Charts as what he wanted. When I first saw that I was impressed.

If you speak about timing... Roel blogged a few days ago with his showcase application of Google Visualizations. He made a nice application which shows a lot of the possibilities the Google Visualizations has. Louis-Guillaume also blogged about his implementation of the Google Visualization Organizational tree and Maps some time ago.

For me personally I'll still use Anychart for the normal kind of Charts, Dashboards and Gantt charts, but I would use Google's for Motion and the Organizational charts.

If you look at how Google Visualizations works; it needs some code to tell it what it needs to render and it needs data in a specific format (e.g. JSON). When I talked to Roel about it he said he made a PL/SQL package that creates the JSON string (in Google format) by passing in a select statement. We wondered if his package could be called by anyone on apex.oracle.com, so we did a quick test where my APEX app calls Roel's PL/SQL package and it worked out nicely.
We had to make some small changes because if you want to call packages from other schemas you want it to run with the data in your schema and not necessarily from where the package is compiled into. You can read more about the Definer and Invokers rights model here, but basically you need to use the AUTHID CURRENT_USER to let it work e.g.

CREATE OR REPLACE PROCEDURE runddl (ddl_in in VARCHAR2)
AUTHID CURRENT_USER

I think the visualization industry is very interesting and it seems more and more people are using graphical representations of their data...

Oracle Database 11g R2 available now

2009-09-01T15:52:00.004+02:00

I always thought Oracle would wait to release 11g R2 at OOW, but apparently Larry has another surprise for OOW ;-)

Today Oracle made 11g R2 of the database available. I'm currently downloading the Linux version and am curious to see how things go with this release. You find more information about the changes in this release in the documentation (New Features section) or in this whitepaper (more marketing material) which also gives an idea why you want to upgrade.

APEX 3.2.1 is included in this release, so when you install this version of the database you have the latest release of APEX immediately.

I didn't use the "Online Application Upgrade" features of 11g yet, but it seems this got enhanced even more in 11g R2. It would be nice to include that in your Supporting Objects in APEX to do an upgrade of your app and underlying data-model.

I guess more and more companies will upgrade to 11g now release 2 is here.

APEX Meetup @ OOW 2009

2009-09-22T15:46:00.006+02:00

As tradition wants, also this year we organize a new APEX Meetup.
Same place, same time!

If you want to have some fun with other APEX-lovers, you are welcome in the Fourth Street Bar & Deli (just across Moscone) on Tuesday 7:30 PM.

Just to get you in the mood, some pictures of last year...

New SQL Developer with Unit Testing

2009-09-24T21:40:00.003+02:00

I just saw a twitter message of Kris Rice, member of the SQL Developer Development team, to announce the availability of SQL Developer 2.1 (Early Adopter).

I installed it on my Mac and it looks really nice. Already from the first screen you see thingst changed. It feels a bit slicker too and runs a bit better and faster at first sight.

One of the biggest new features is the Unit Testing framework for PL/SQL. I did some quick tests and it looks ok. You still need to do quiet some steps to create your tests, but as with every new thing, I guess it's a matter of getting used to it. So far there was only one real nice unit testing app for PL/SQL and that was Steven Feuerstein (Quest) Code Tester. So I'm really curious to find out how much difference there is. One of the biggest advantage of the SQL Dev Unit Testing is it runs native on Mac :-)

There are some other small enhancements in SQL Dev 2.1 like opening a package directly in Edit mode and Code Templates, they will both save me a lot of time! It's also nice there is a viewer of the Data Modeler build-in now.

A complete list of New Features you find here.

Mac is cool or not?

2009-09-30T09:34:00.003+02:00

At the worst possible times things happen... so was for me two days ago.

In the morning I worked without a problem, went for lunch and when I came back my Macbook Pro didn't come out of sleep mode anymore :-(
It's a Mac right, they don't break! So tried several things to reboot, but I just heard the startup sound but nothing more happened. Called John as he might have an idea, so we tried several other things, but no heartbeat in that laptop anymore...

Two hours later, went to the Apple shop and let their expert look at it. Their diagnose was the graphic card of the laptop broke and it was a common problem lately! Apple recognizes the problem and offers a free replacement and fix. So that is pretty cool...

The problem is I can't really without laptop and it would take several days (a week) to get it fixed. The Apple store couldn't give me a replacement laptop for a few days, so my only options were to use my Mac Mini (Server) or buy a new laptop.

Luckily I've a Mac Time Capsule that takes a backup of my systems every hour, so I finally decided to buy a new laptop and hoped for the best with the backups.

I must say, Time Capsule is awesome. I fired up my new laptop, got to the latest release of OSX and run the Migration Assistant (under Utilities). You tell the wizard you want to restore your machine from your Time Capsule and some time later (it had to copy a lot of GB) I was up-and-running again!

The things to remind;
- Make sure you have backups, the maximum I would lose is an hour work
- Make sure you remember the passwords of your Time Capsule, network etc
- Create a new Admin User, it makes it easier to import the users

So is Apple cool?

It was not so cool my laptop broke, but I get it fixed for free and the backup strategy with Time Capsule works flawlessly... and it's nice to have a new laptop as well ;-)

APEX 4.0 EA almost near

2009-09-30T21:57:00.004+02:00

I just read on David Peake's blog he's preparing for Oracle Open World and in that article he gives some more news about APEX 4.0.

The APEX Development team worked hard the last months (and year) on APEX 4.0.
As with previous versions they normally put an Early Adopter (EA) version online before they release it to the public. David writes that although APEX 4.0 is planned for 2010, the APEX 4.0 EA is not that far of anymore. I think that is definitely something to look forward too.

I strongly believe APEX 4.0 will change the way we build applications again. If you work already a long time with APEX and have done several projects with it, you see how APEX could be improved or how it would make your life even easier. If I look at the video of APEX 4.0 of June and the available presentations and screenshots I see the development team hit the nail on the head (again!). If you just think about AJAX, the Plugin system, Team Development and all the rest they added or upgraded... believe me it will be a killer product.

I'm not sure you know Mike Hichwa was nominated for the Innovation Showcase (congratulations!). I had the pleasure to talk to him more than once and next to his brilliant mind and his coding skills, I admire him because he listens to people. Even when APEX was not as hot as today, he had the desire to make a good product for the people which they would love to use.
But of course it's not only Mike, it's the whole team behind APEX that make it successful. One by one they are very intelligent and highly motivated people.

I already would like to say "Thank you" to the whole team! Not only for the upcoming release, but also for all the previous years. Day-in day-out I feel blessed I can work with such a nice product as APEX and talk with the nice people behind it.

APEX Listener available for download

2009-10-06T20:22:00.003+02:00

The Oracle Application Express architecture requires some form of Web server to proxy requests between a Web browser and the Oracle Application Express engine. So far you had following possibilities:

Oracle HTTP Server/mod_plsql
XDB HTTP protocol server/embedded PL/SQL gateway

Today Oracle made the Early Adopters of the Oracle Application Express Listener available.
It's an alternative that is offered for the above two and with APEX 4.0 it will become the first choice.

Below you see a slide of the APEX 4.0 presentation. It explains what happens more graphically.

The main reasons why you want to consider the APEX Listener:

it supports file system caching
it makes the printing of pdfs easier as the APEX Listener is build in Java and integrates nicely with FOP.
support of multiple file upload, the architecture of mod/plsql didn't allow that
you can add your own plugins to it
it has a workload capture feature

As the listener is written in Java you need a J2EE runtime environment. The Oracle Application Express Listener supports Web Logic , Tomcat, and OC4J. My personal preference would be Tomcat or Web Logic, if you need more features.

Leaving for OOW, let the fun begin

2009-10-07T00:32:00.003+02:00

In a few hours I'm starting my journey to the States.

On Wednesday I fly from Brussels to Los Angeles (with a stop in Heathrow). At night I have a dinner planned with a friend and his family. I find it always good to try and stay awake the first day and get in the rhythm of the local timezone.

Thursday I'm doing a client visit and in the evening I'm on the plane again to San Francisco.

Friday I join the other Oracle ACE Directors for a visit to Oracle HQ where we get some previews on what is coming.

Saturday will be the calm before the storm... because on Sunday the madness starts. San Francisco will color red and everywhere you'll see people for Oracle Open World.

My adapted schedule looks like this (in red is where I present):

Look forward meeting you at OOW...

First days in the States

2009-10-09T17:31:00.006+02:00

I guess I'm lucky... just as my last flights I got upgraded again. But this time I didn't only get upgraded with my flight, but also the car I hired, the room I stayed in, amazing! I guess I must have been a very lucky person.

It was the first time I drove with an Escalade. I really liked the car. It had so many features e.g. a camera at the back to see what is behind you when you are in reverse.
In the hotel I got a room with a hot-tub, that was really nice after a long flight.

Below you see some the picture of the luxury bathroom and our night out with Rich and his family. I always enjoy spending time with them.

Our flight to San Francisco was delayed so I only arrived in the Sofitel hotel across Oracle HQ at midnight. Now it's time for the Oracle Ace Directors meeting.

Oracle HQ

2009-10-10T07:14:00.004+02:00

Today was my first time at Oracle HQ in San Francisco. Very nice environment, impressive buildings, ... what you can expect of Larry Ellison I guess.

At the Oracle HQ we got a briefing of the upcoming products. We are not allowed to communicate about it yet, but I can say there are some impressive things coming.

Mike Hichwa also showed APEX 4.0, although I had already seen it, APEX changed even more and more nice features are in. For me it will be the biggest release (in number of new features and enhancements) of APEX since the beginning!

Thanks to Duncan Mills for hosting the briefing, I really enjoyed it.

Here are some pictures of myself at Oracle HQ and the other Oracle ACE Directors in the Oracle HQ building, enjoying some drinks and food.

OOW09 Sunday - Full APEX day

2009-10-11T18:06:00.004+02:00

Registration was very fast at OOW, no queues this morning.

It's still early in the morning while I'm writing this post... not that many people arrived yet. But you can be sure, today the madness begins ;-)

There will be 30 (official) APEX presentations at OOW (and some others at the Unconference).

I'm on stage three times today. Together with Scott I'll open the APEX Symposium where we focus on migrations to APEX.

During the Symposium I also have another session "Mastering an APEX page" in the Hilton Hotel (Golden Gate 4/5).

And after the APEX 4.0 presentation we'll do the "Ask the Experts" panel where you can ask any question you like. Joel Kallman, John Scott, David Peake, Scott Spendolini and myself will be on the panel.

OOW09 APEX popular at OOW?

2009-10-11T23:39:00.007+02:00

Every year the APEX presentations get more attended... but this year at OOW it's a bit extreme...

Have a look at the below pictures:

Indeed queues of people for the APEX 4.0 session of Mike Hichwa and David Peake.

*** APEX 4.0 will be hot for sure ***

APEX Developer of the Year 2009

2009-10-13T06:52:00.002+02:00

I just saw the Oracle Magazine for November/December edition... I already knew it a bit before, but now it's official; I got the "APEX Developer of the Year 2009" award.

Of course I find it a real honor and I appreciate the recognition. Thank you Oracle Magazine and APEX Development team!

Pics of Oracle Ace's dinner - Oracle Nerd

2009-10-18T06:50:00.007+02:00

I'm a bit behind with blogging about Oracle Open World 2009, but I promised to post some pictures of the ACE's dinner of Monday.

It was my first ACE dinner and I liked it very much. I had some nice food and drinks with all the other ACE's at OOW. Thanks to Vikki, Lillian and Duncan for the organization.

Mark Rittman and John Scott tasting some beer ;-)

Before OOW there was a whole story/thread about getting Oracle Nerd aka Chet Justice to OOW, one of them was to buy special Oracle Nerd shirts... so Chet, here are some pics of the ACE's wearing the shirts! Vikki and myself, showing the Oracle Nerd shirt.

Lillian M. Buziak, Steven Feuerstein and Andreas Chatziantoniou.

OOW09 - Dashboards in APEX

2009-10-18T07:23:00.015+02:00

One of the presentations I did at OOW09 was Impress Your Clients with Interactive Dashboards in Oracle Application Express.

The session was booked in the Franciscan A and B room of the Hilton Hotel. So the room was pretty big (around 200 people I think) as two rooms were put together. I like to do interactive presentations, but in such a room e.g. there were two project (one at every side of the room) that is not that easy.

In this presentation I first explained which charting capabilities you get out-of-the-box with APEX, followed by how you can transform these charts into nicer ones. If you really want to impress your clients, Interactive Dashboards are the way to go. Basically a dashboards is one big chart which consist out of different views who have all an own chart.

Having only one swf and one data feed makes it faster than when you would create three separate charts. Anychart 5 provides a nice API to generate these dashboards.

You have different possibilities to feed the chart with data, one of them is creating an Application Process that generates the XML for the dashboard. e.g.

If you want to add Interactivity to your chart, you will need to use JavaScript.

In the presentation I covered all steps in detail. At OOW the presentation got recorded as well so when they release the audio streams, you can hear it there too. I'm also giving this presentation again at UKOUG.

You find the example I explained in the presentation here.

In APEX 4.0 the creation of dashboards will become easier as there will be a wizard in. So far I didn't see a demo of that yet, so I'm not sure how and what features they will include.

At the end of my presentation I also showed a preview of the new chart engine Anychart is working on, called Stock Charts. They are not released yet, but I'm working with them to make the integration with APEX easy. I'm really exited about these new charts! If you need financial charts or charts that are based on dates, these new charts rock!

OOW09 - APEX Meetup

2009-10-18T10:24:00.010+02:00

As an annual tradition, also this year we had an APEX Meetup at the 4th Street Bar & Deli during Oracle Open World.

Every year the numbers of people coming to this meetup is increasing. People from all over the world talk about APEX and make fun. The APEX Development team was also present.

And this year we had some sponsors too: ODTUG, OTN and Oracle APEX team were so nice to pay for our drinks. So a special thanks to the complete ODTUG board, Justin and Lillian of OTN and Joel of the APEX Development team!

Below you find some pictures...

A lovely evening with all nice people, a day to keep in memory...

APEX 4.0 Screenshots and first impression

2009-10-28T23:25:00.000+01:00

At the demo grounds of OOW09 the APEX Development team showcased APEX 4.0.

I spend quiet some time at the demo ground to play a bit with APEX 4.0 and have a real feeling about this new version. I liked it a lot, but to be fair not all wizards were finished/polished yet and while I was testing I wanted even more features. There are so many enhancement requests they can put in, so it will be a challenge to define the final list of which will be included and which will be postponed to APEX 4.1.

I took some screenshots to show you how things look like and commented a bit on it.

All the screenshots might look different when APEX 4.0 hits the roads, so don't take it for granted it will be like that in the final version.

I already wrote some other blog post and posted a video over a year ago (!) about Websheets. It will be "separate" from APEX e.g. you create a Websheet or an APEX app. I see Websheets as "APEX lite" or "APEX for business people". It's even easier and faster to create a Websheet than it is to create an APEX application. Everything is in meta-data, so Websheets are not based on real tables, but the tables will be defined in meta-data. This allows people to change the structure of the table on the fly (e.g. add columns).
It has some other nice features like inline editing, sharing of your data (security build in), flashback capabilities and so much more... definitely one of the reasons to go with APEX 4.0.

When you login into APEX 4.0 you see that the Application Builder got a nicer look and feel. The new color is blue instead of green and it looks like an enhanced version of Theme 20 is used.

Drilling down into an Application gives you the next screenshot. The quick links which I use a lot (edit page, wheel to access shared components, ...) got extended. The search functionality there will save everybody a lot of time.

At the last conferences I gave a presentation about "Mastering an APEX page". It looks like I should redo that presentation when APEX 4.0 comes out. Although the Page Layout already changed a bit (e.g. you have now a Dynamic Actions section) insiders told me that it's likely to change more.

If you don't like to touch javascript yourself, but you need things to happen on the client (cascading lovs, hide/show items and regions) the APEX dev team build Dynamic Actions for you. It allows you to build these things in a declarative way.

The different actions in Dynamic Actions through the wizard

If you edit the Dynamic Actions you can change it even more.

The Utilities section got revamped with more features and more logical organized items.

One of the new items is the Advisor. Before you could find that in Patrick Wolf's APEX Essentials. So now it will be build-in and it got more enhanced as well. This will definitely mean everybody can do easier Quality checks of their applications.

Team Development will be another nice feature. It allows the people on the project to work more closely together and all throughout the APEX interface. New features, bugs and to-do's can be logged and be assigned to people. This is an example of something we build ourselves too to make our live easier, but as a lot of the things we did before in our own way, APEX 4.0 will give you everything (or at least a lot) build-in.

The new Shared Components section got some more features, the most important one I would say is the access to the Plugins.

I'm expecting a lot of the ability to have Plugins in APEX 4.0. I've certainly a couple in my head I'd like to write, but it's just the fact that it opens up APEX in every way. If you do something in many projects and you can't use Shared Components for it, it makes sense to write a plugin, so it makes it easy to reuse.

As a frequent reader of this blog you probably know by now that Anychart 5 will be integrated in APEX 4.0. The new wizard looks a lot cleaner. You see which chart you want and select that from the start in the wizard. There are also other types of charts available now e.g. Gauges and Gantts.

The below screenshot shows the new wizard for creating Maps.

The next screenshot shows you the Enhanced Interactive Reports with a Map on the same page. As you can see the Interactive Report got some new features like Group By.

I think APEX 4.0 will change the way we write applications. APEX 4.0 brings us again to another level of web development in a declarative way. You'll be able to do things in an easier and faster way than ever before. I already look forward to next year when we can develop with it...

ODTUG 2010 submission deadline

2009-10-30T00:49:00.001+01:00

Every year the Oracle conferences are a place to meet other fellow Oracle people and hear the latest and greatest in Oracle world.

Normally these are the conferences I go to: IOUG Collaborate, ODTUG Kaleidoscope, Oracle Open World, UKOUG and some smaller local ones.

One of the ways to get a free pass to these conferences is to present. ODTUG was the biggest APEX conference last year and for 2010 it will be no different. Especially with the release of APEX 4.0 it will be interesting to see these new presentations. The submission deadline for ODTUG just got extended, so now there are another 10 days left to submit an abstract for the ODTUG conference...

It will be nice for me personally to go back to Washington as that was the place I went to on my first visit to the States.

Good luck with the submission!

Testing Syntax highlighting

2009-11-03T07:34:00.003+01:00

I found following blog post which explains how to include SyntaxHighligther (v2) in blogger.

So lets give it a try for the languages I use most.

SQL


SELECT ename, empno
  FROM emp
WHERE empno = 7654;

PL/SQL (same highlighting as SQL)


BEGIN
  FOR r in (SELECT ename, empno
              FROM emp)
  LOOP
    htp.p(r.ename);
  END LOOP;
END;

JavaScript


$(document).ready(function() {
  $(".btn-download").click(function(){
    callMyFunction();
  });
});

XML

Accordion in APEX

2009-11-04T21:00:00.001+01:00

*** This post uses SyntaxHighlighter to show code, if you are on an RSS-reader you might not see the code ***

The last weeks it seemed that more people were having the same question "how to integrate an Accordion in APEX".

I've been using an Accordion for a while, an online example is on the Anychart Integration kit website. The left-hand menu is an Accordion.

I think on all my projects of the last year I've been including JQuery and JQuery UI as a standard in the template. The Accordion I use is part of JQuery UI.

You can implement the different JQuery components and plugins in a lot of different ways in APEX; using a template, a shortcut, a region etc. but the principle is the same for any way you chose; you need to load the necessary javascript and have some html that works with it.

My standard philosophy is "if you can make things reusable, you should do it". (with this note: if time and effort allows)
APEX has a Shared Components section and Page zero which can help you with sharing your most common used code. APEX 4.0 will go a step further and provides a plugin mechanism, so you don't need to put the code in different places anymore, instead it will handle everything for you.

So to implement my Accordion, I used a List Template to change any List into an Accordion. Here's how the APEX list template looks like:

List Template Before Rows

List Template Current


#TEXT#

List Template Noncurrent


#TEXT#

Between List Elements

Sub List Template Current


#TEXT#

Sub List Template Noncurrent


#TEXT#

List Template After Rows

Update; apparently SyntaxHighlighter can't show the script tags (javascript).

The List is a normal list as you can see in the below screenshot.

In the List itself you need to add the pages in "List Entry Current for Pages Type" in order to leave the Accordion open for a child. e.g. 2D Column is page 10 and that should be in the List Entry Current for Page 5.

So in every other project you can just use this template for a list and you have an Accordion in place.
javascript:void(0)