Useful SQL Commands

In the late 1990’s I took several professional development courses at a WPI satellite school, which eventually led to my current career track as a web application developer. One of the courses involved an introduction to database theory. At the end of the course the professor passed out a page of useful SQL commands that we would probably have need of at some point in our lives. I’ve held on to it for a long time and have referenced it often. I’ve decided to post it here for two reasons: It’s easier for me to find this way (and I can bookmark it), and someone else might find it useful. The tips were specific to Oracle, but I imagine (I’m not a DBA so don’t take my word for it) that most of these commands, if not all of them, are valid under many modern Db engines.

Useful SQL Commands.pdf

* This post was originally published on December 18, 2006 at http://www.csb7.com/blogs/whyblogwhy/2006/12/18/useful_sql_commands

Hargo Day was established to also recognize the human capacity for appreciation, wonder, and awe that can be achieved when small plastic things are arranged in a certain order near and around a cat

— Mayor Curtatone of Somerville, MA., in declaring Feb. 24, 2005 as “Hargo Day”, http://www.boston.com/news/local/massachusetts/articles/2005/02/25/tiny_takeoff_on_christo_proves_gateway_to_glory?pg=2