- Pretty PL/SQL
September 6, 2015Presenting PL/SQL code snippets in web pages, complete with syntax highlighting using Google Code Prettifier.
- PL/SQL Developer Setup, part 2
October 12, 2014Like other database IDEs, PL/SQL Developer includes a session browser that essentially shows the contents of v$session, with some tabs for the current SQL statement, locks, waits and so on. The default settings are rather basic, but the...
- PL/SQL Developer Setup, part 1
November 10, 2012PL/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...
- You Probably Don't Need VARRAYs
July 29, 2007In PL/SQL, the VARRAY is merely a functionally crippled version of NESTED TABLE with a LIMIT attribute you don't need. Here are what I consider the main points of the different collection types, from the point of view of a PL/SQL...
- How to configure an NFS share from Mac OSX to CentOS
January 24, 2007If 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 set up SQL*Plus
October 19, 2005Despite 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.
- Comma-separated output
October 15, 2005What 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 15, 2005After "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?"