Posts in SQL
Partition Outer-Joins

Oracle Database 10g brings a new feature called the "partition outer-join". You use the feature to "densify" data, to fill in missing rows in a result set. It's far more useful than I'd first realized, and it's elegant too.

Read More
Oracle, SQLJonathan GennickSQL
An Incremental Approach to Developing SQL Queries

The key to getting accurate information from your database is to write good SELECT statements. In fact, it's the key to just about everything you do with your data. Even the tasks of updating and deleting data depend on your ability to select the relevant data in the first place. Because selecting the correct data is the foundation for much of what you do with your database, it's worth taking some time to think about how you write SELECT statements.

Read More
Managing Database Objects in Groups

The typical database contains a large number of tables, indexes, and other objects. Dealing with these objects on a one-by-one basis quickly becomes a complex and unmanageable task. One way that I've found to reduce this complexity is to deal with database objects in groups, or sets.

Read More