Author Archives

ODTUG APEXposed 2012

What more is there to say? This event is going to be fantastic and there’s still time to register!

ODTUG APEX Plug-In Competition

As Martin has already announced, there is a very exciting APEX Plugin Competition hosted by ODTUG. Here’s the official announcement (taken from the ODTUG page): ODTUG is holding its first ever world wide APEX Plug-ins competition! This is your opportunity to write an APEX plug-in and have it viewed by the entire international APEX community and [...]

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 [...]