Tony Andrews

Subscribe to Tony Andrews feed
Some very occasional musings on matters concerning Oracle specifically or databases in general.Tony Andrews
Updated: 6 days 11 hours ago

APEX conditions and performance

Sat, 2013-04-06 06:45
Having recently seen some examples of non-optimal code in APEX conditions (e.g. item rendering conditions and read-only conditions)  I thought it worth writing a few words about them.  By putting them here on my blog I can refer to them in future rather than writing them again. Also I may receive useful feedback from readers to improve or correct my advice. For a very simple condition Tony Andrews

The curse of the cursor

Tue, 2011-04-19 04:58
For some reason, many Oracle developers avoid SELECT INTO as if it were dangerous, preferring to "have more control" over their code by using cursors for everything. This morning I spent over an hour debugging some code written by one such developer, only to find that the issue I was trying to fix was one that would have been caught by the original developer immediately had he used SELECT Tony Andrews

Apex MP3 Player item plug-in

Mon, 2011-04-04 11:18
I have developed a plug-in item type that renders an MP3 player to play a specified audio file using the free Premiumbeat Single Track Flash MP3 Player. The file may be specified via a URL of as the ID of a file stored in APEX_APPLICATION_FILES. There is a demo of this available here on plug-in has the following settings available:They are mostly fairly self-explanatory (and Tony Andrews

Dutch Oracle User Group's Apex Day 2011

Fri, 2011-03-25 06:32
This week I attended the Dutch Oracle User Group (OGh)'s Apex Day as a presenter, along with an ex-colleague from Northgate, Nigel Blair. We were talking about how we converted 1500+ Forms modules to Apex. There was quite a lot of interest from the 250 people present. We hope the interest wasn't due to a mix-up in the agenda that had us down as Nigel Andrews and Tony Blair!Luckily we were on Tony Andrews

Fame at last for my biggest Apex project to date

Mon, 2010-08-09 11:32
I'm very pleased to see that the Apex project I started and worked on for several years is now the subject of an entry under Customer Quotes on the OTN Apex page."At Northgate Revenues & Benefits, we have used APEX to replace our legacy Oracle Forms system comprising around 1500 Forms. Our user interface has 10,000 end users daily, across 172 clients, who this year sent out over 12 million Tony Andrews

SQL Overlap Test

Wed, 2010-06-23 05:20
Many times I come across SQL where the developer is trying to check for overlap between two ranges (usually date ranges, but sometimes numbers). For example, to meet the requirement "select all employees whose hired from and to dates overlap with the project start and end dates".The developer sketches out all the possible overlap scenarios and finds four:1) End of range A overlaps start of rangeTony Andrews

Shameless boasting

Fri, 2010-06-04 05:44
I hate to boast but...StackOverflow has become one of my favourite forums for reading and sometimes answering Oracle-related questions (though it covers all programming topics in fact).Today I am the first person ever to be awarded the Oracle badge for having earned 1000 upvotes for my answers to questions with the Oracle tag:Of course, this may just mean I have too much time on my hands...Tony Andrews

Chris Date Seminar

Wed, 2010-03-24 08:31
Chris Date is giving a 2 day seminar called SQL and Relational Theory - How to Write Accurate SQL Code in Edinburgh, 13th-14th May 2010. I really wish I could go to it myself. I attended one of his seminars back in about 1997 and it was both riveting and highly educational.Tony Andrews

Apex 4.0 - no more dummy branches required

Thu, 2010-03-04 11:43
How many times do you see this error page while building an Apex page?ERR-1777: Page 1 provided no page to branch to.Please report this error to your application administrator.To avoid that, I have a habit of creating an unconditional branch back to the same page in every page I build, with a sequence number higher than all the conditional branches. If I then add new conditional branches I have Tony Andrews

Trying Out Apex 4.0 Dynamic Actions

Tue, 2010-03-02 10:34
In my spare moments I am currently familiarising myself with the Apex 4.0 Early Adopter edition. One of the many exciting new features is Dynamic Actions. These allow you to add functionality to your pages that would previously have required writing Javascript, AJAX calls and On Demand PL/SQL processes, but can now be done declaratively.The following very simple example shows 3 uses:1) EnablingTony Andrews