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

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”,