Oracle Netherlands 25 years

This year is the 25th anniversary of Oracle’s branch in The Netherlands. For this occasion Oracle has organised an event in Aalsmeer on november 19th.
My employer Whitehorses is a silver sponsor for this event. You can visit our stand for more information on the company and how we can help you solve your IT-problems.
For more information visit the event’s website.

Smart queries: find duplicate rows

On every project I’ve worked for the past few years, there came a question to find all duplicate rows in a table. And every time I mix up some of the code. So now it’s time to post the right code on my blog, so I can always find it back :-)


SELECT employee,
COUNT(employee) AS Occurrences
FROM emp
GROUP BY employee
HAVING ( COUNT(employee) > 1 )

Application Express Listener available

Oracle has put the Application Express Listener up for download. It’s an early adopters release, so it’s not supported, but I think it’s still worth giving a try.

The download is available at: http://www.oracle.com/technology/products/database/application_express/html/apex_listener_download.html

I think it’s a very significant change in Apex. This allows developers to use their existing web server (like Tomcat or Weblogic), instead of Oracle HTTP Server/mod_plsql or the XDB HTTP protocol server/embedded PL/SQL gateway.

Read the Installation Guide for more information.