E-Book Content
Advanced SQL Database Programmers Handbook Donald K. Burleson Joe Celko John Paul Cook Peter Gulutzan Advanced SQL Database Programmers Handbook By Donald K. Burleson, Joe Celko, John Paul Cook, and Peter Gulutzan Copyright © 2003 by BMC Software and DBAzine. Used with permission. Printed in the United States of America. Series Editor: Donald K. Burleson Production Manager: John Lavender Production Editor: Teri Wade Cover Design: Bryan Hoff Printing History: August, 2003 for First Edition Oracle, Oracle7, Oracle8, Oracle8i and Oracle9i are trademarks of Oracle Corporation. Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks. All names known to Rampant TechPress to be trademark names appear in this text as initial caps. The information provided by the authors of this work is believed to be accurate and reliable, but because of the possibility of human error by our authors and staff, BMC Software, DBAZine and Rampant TechPress cannot guarantee the accuracy or completeness of any information included in this work and is not responsible for any errors, omissions or inaccurate results obtained from the use of information or scripts in this work. Links to external sites are subject to change; DBAZine.com, BMC Software and Rampant TechPress do not control or endorse the content of these external web sites, and are not responsible for their content. ISBN 0-9744355-2-X iii Table of Contents Conventions Used in this Book ....................................................vii About the Authors ...........................................................................ix Foreword.............................................................................................x Chapter 1 - SQL as a Second Language................................. 1 Thinking in SQL by Joe Celko .................................................