tag:blogger.com,1999:blog-173386562008-07-14T15:35:50.165+01:00William Robertsonnoreply@blogger.comBlogger8125I'm finally organising the articles, tips and rants into a proper RSS-enabled system. Here it is.http://www.williamrobertson.pwp.blueyonder.co.uk/gifs/websitelogo_chromestretched.jpgSubscribe with My Yahoo!Subscribe with NewsGatorSubscribe with My AOLSubscribe with BloglinesSubscribe with NetvibesSubscribe with GoogleSubscribe with PageflakesThis is an XML content feed. It is intended to be viewed in a newsreader or syndicated to another site, subject to copyright and fair use.tag:blogger.com,1999:blog-17338656.post-56035894844666994722008-07-14T15:09:00.002+01:002008-07-14T15:12:04.908+01:00PL/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...William Robertsonnoreply@blogger.comtag:blogger.com,1999:blog-17338656.post-29206805278965493692007-07-29T20:06:00.000+01:002007-07-29T20:09:40.640+01:00I 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...William Robertsonnoreply@blogger.comtag:blogger.com,1999:blog-17338656.post-1169654320034752392007-01-24T16:56:00.000+01:002007-01-24T17:05:45.460+01:00If 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...William Robertsonnoreply@blogger.comtag:blogger.com,1999:blog-17338656.post-1165934132974453312006-12-12T15:31:00.000+01:002006-12-12T15:35:50.833+01:00Currently 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...William Robertsonnoreply@blogger.comtag:blogger.com,1999:blog-17338656.post-1129763826638257642005-10-20T00:15:00.000+01:002005-10-20T00:17:06.643+01:00Despite 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.William Robertsonnoreply@blogger.comtag:blogger.com,1999:blog-17338656.post-1129540439626785042005-10-17T10:10:00.000+01:002005-10-17T10:13:59.633+01:00This 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.William Robertsonnoreply@blogger.comtag:blogger.com,1999:blog-17338656.post-1129396460254992052005-10-15T18:11:00.000+01:002005-10-15T18:14:20.256+01:00What is it with comma-separated lists? Anyway, here are some techniques for generating one comma-separated list from multiple rows in SQL.William Robertsonnoreply@blogger.comtag:blogger.com,1999:blog-17338656.post-1128862927513155502005-10-09T14:00:00.000+01:002005-10-15T18:19:54.856+01:00After "How do I display values from multiple columns in one comma-separated row", one of the next most-asked Oracle questions on the web is the opposite one (sort of): "I have a comma-separated list. How do I use it in SQL queries?"William Robertsonnoreply@blogger.com