Author Archives

APEX Quiz

APEX Quizzes Start on 18 June 2011 With the growing popularity and usage of Oracle Application Express, we are very excited to announce a new weekly Oracle APEX quiz launching on Saturday, 18th June. Weekly quizzes start on Saturday and end on Friday at midnight (UTC). We have been deeply involved in the development (and [...]

Expert Oracle Application Express

It’s been around 3 years since I wrote Pro Oracle Application Express (with a chapter contributed by Scott Spendolini), and like most first time authors I said “That was a great experience, but I’m in no hurry to write another book again!”. Writing a technical book is a very rewarding experience, but trying to do [...]

APEX 4.0 released

APEX 4.0 just got released, this is the BIG one for APEX developers, we’ve been anxiously awaiting the release (and a few bets have been known to placed on when exactly it would be released!). More information is available on Joels blog, and you can download APEX 4.0 as always from the main OTN APEX [...]

PL/SQL Challenge – Goes Live!

The PL/SQL Challenge website has just gone live! If you haven’t heard about it yet, it’s a website where you can pit your wits against a daily question by none other than Steven Feuerstein (yes that Steven Feuerstein!) and Finn Ellebaek Nielsen. Wait it’s even cooler than that, you can win cash (and other!) prizes [...]

Application Express 4.0 – Early Adopter 2 Now Available

If you didn’t already see the news, the EA2 release of APEX4.0 has just been opened up. Head over to www.tryapexnow.com, sign up for a workspace and try out all the cool new features. EA2 includes the following key features – Websheets (this will be huge!) New collection enhancements Tree region Debugging has been rewritten [...]

Views and Order By

Developers like views…they can simplify things and hide (protect us from) underlying complexity. For example, would you rather write the query – SELECT ename, department_name FROM emp_vw or SELECT e.ename, d.dname FROM emp e, dept d WHERE e.deptno = d.deptno; It’s a rhetorical question so please don’t say “I prefer the second”…otherwise there’s no point [...]

Increasing the speed of APEX Collections

I’d love to say “I’m quite often asked…”, but to be honest hardly anyone seems to use Collections in APEX (a very under utilised feature in my opinion). However, a question does come up from time to time, often along the lines of “I am using a collection but it is slow…”. Typically, you might [...]

APEX Listener EA2 is out!

Just a quick note to say that the APEX Listener Early Adopter 2 is out. Kris Rice blogged about the features and fixes available in this EA, I just quickly tested out the XLS upload (turns it into an APEX collection….very very cool!). The APEX Listener is definitely introducing some interesting features (like the ability [...]

APEX@Your Oracle Usergroup

Just a quick note to say I often get asked if I can present at a Oracle usergroup meetings. The answer is usually ‘yes I’d love to’, since – 1) I love to talk about and promote APEX 2) I love to travel So, if you have an Oracle usergroup and you’re interested in promoting [...]

Advert: Oracle APEX Training in Manchester, UK

As Dimitri has already blogged, this year we are focussing on doing a lot more Oracle Application Express training events. With that in mind, the first public training I’m doing this year is 3 day Introduction to Oracle Application Express in Manchester on the 22nd March. Here’s an except from the course description – Introduction [...]