Oracle ‘isnumeric’ function

A possible implementation is to simply try to assign the string to a number and catch any exceptions. If something goes wrong then it's not a number!

Returning Oracle SQL data as XML

An earlier post illustrated how to extract information from XML inside PL/SQL. This post is an example of the reverse of this, in that it shows how to create an XML document from a SQL statement. These examples are based on creating an XML document providing details of the tables in the SCOTT schema but could easily be adapted to suit your needs.

oui.exe crash on Oracle patch

This is just a simple little post but one which was frustrating for us for a while earlier today.  When trying to run setup.exe to install the patchset for Oracle 10g on a Windows XP Pro machine (this may happen on other flavours of Windows, I'm not sure) it pretty much immediately crashed with an error in oui.exe.

After much digging it turns out that the problem is simply that…

Returning an SQL result to a Shell script

Often it can be useful to return the result of a simple SQL*Plus query to a shell script variable, for example to check for a value before deciding wether or not to proceed. The syntax is actually pretty simple :

Updating Oracle tables using a join

Doing a 'join update' in Oracle can sometime cause a few headaches. By 'join update' I mean the situation where we have two tables and want to update some of the rows in the first table based on values that exist in the second table.

Building an OCCI project using XCode 3.1

With the release of the Instant Client for Mac OS X you can now build OCCI based applications targetting modern Macs using Leopard on Intel. However, there is very little help available for building these apps using XCode, and if you hit the same problem we did (see below) then perhaps this post may be helpful.

Things we like about the Mac

As you may have gleaned from other posts we do a lot of development using Macs, specifically MacBooks and iMacs. We might develop products that run on Linux, Windows or Solaris but that doesn't stop us using our Macs to actually do the work!

ApEx Select list with Redirect confirm change

We recently had a situation that required a little bit of head scratching. We had a page with a Select List with Redirect that was used to populate some form fields based on the contents of the Select List. The users could change the values in the form and save them, but if they changed the Select List before using the 'Save' button then the changes would be lost. What we wanted to do was add a confirmation message to make sure the user saved the details before changing the Select List.

Using Ajax to populate one field based on another in an ApEx form

Often it can be useful to populate one field on a form based on the content of another in a live and dynamic fashion. Luckily this is easily achieved using the Javascript API supplied as part of ApEx 3.1.

Editting ApEx theme images using Mac OS X and WebDAV on XE

Recently we had to make a couple of minor tweaks to a couple of ApEx theme images stored in an XE installation. At first we scratched heads a little but then found a helpful post on the ApEx forum which made it much easier. All we needed to do was work out how to do this using Mac OS X Leopard. Luckily, it's also very easy!


  • oracle (8)
  • Mac OS (6)
  • Oracle (6)
  • SQL (5)
  • apex (4)
  • mac os (3)
  • iPhone (3)
  • script (2)
  • GIS (2)
  • map (2)