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

Research is what I’m doing when I don’t know what I’m doing.

— Wernher von Braun