Just found an interesting article by David Peake (APEX product manager), in the September / October '07 edition of Oracle magazine, entitled 'Express 2.0'. This gives a brief introduction into implementing AJAX based functionality into APEX applications, and then goes onto a step-by-step example on how to implement dynamic tooltips.
Worth a look.
Update: David has just started his own blog so be sure to add it to your feeds!!