- Setting up PL/SQL Developer, part 1
July 14, 2008
PL/SQL Developer is one of several integrated development environments (IDEs) that are available for Oracle, and it happens to be my favourite. One of the things I like about it is how configurable it is - you can change almost anything, and with downloadable plug-ins such as Browser Extender you can add your own functionality. - Collection Types (or, You Probably Don't Need VARRAYs)
July 29, 2007
I often see questions on technical forums about arrays in PL/SQL, which type to use and what the differences are. Although the documentation has quite a lot to say on the subject, I personally think it tries to introduce too many concepts at once... - How to configure an NFS share from Mac OSX to Linux
January 24, 2007
If you install CentOS or another free Linux on your Mac in a Parallels VM (for example as a platform for Oracle), you will notice early on that there is no way to share files between the host Mac and the VM. This functionality is provided for those... - How to install Oracle 10g on Apple Mac
December 12, 2006
Currently there is no Oracle RDBMS product for Intel Macs. However, using Parallels you can have it running in a CentOS virtual machine, and access it through your Mac's web browser or even SQL*Plus on the Terminal command line. Here's how... - How to set up SQL*Plus
October 19, 2005
Despite living in the era of GUI tools such as PL/SQL Developer, there are times when a simple text browser is all you want. Here's how to get the most from SQL*Plus. - Database scripting considered harmful
October 17, 2005
This article is an attempt to explain why I believe that scripting is in general unsuitable for database applications. It is written with Oracle and shell scripts in mind, but I believe it applies to just about any database and scripting language. - Comma-separated output
October 15, 2005
What is it with comma-separated lists? Anyway, here are some techniques for generating one comma-separated list from multiple rows in SQL. - Comma-separated input
October 14, 2004
I have a comma-separated list. How do I use it in SQL queries?
