Synopses & Reviews
SQL (Structured Query Language) is the heart of a relational database management system. It's the language used to query the database, to create new tables in the database, to update and delete database fields, and to set privileges in the database. Oracle SQL: The Essential Reference is for everyone who needs to access an Oracle database using SQL--developers, DBAs, designers, and managers.SQL is based on research dating back to the late 1960s, but its first commercial release was in the RDBMS announced by the fledgling Oracle Corporation in 1979. Since that time, every other database vendor has adopted SQL, and ANSI and the ISO have made it a standard. Although vendors diverge in their extensions to SQL, the core language is standard across vendor boundaries.Despite SQL's long history and relative simplicity, few developers and database administrators are truly masters of SQL. The constant stream of vendor enhancements, the hard-won experience in tuning SQL for best performance, and the requirements of particular operational environments mean that there is always more to learn about SQL.Oracle SQL: The Essential Reference delivers all the information needed to keep ahead of the learning curve on standard SQL and Oracle's extensions to it. This single, concise reference volume will hold its own against a stack of Oracle manuals and even yield insights and examples not available in those manuals.There are chapters on basic SQL elements (naming requirements, column types, pseudo-types, data conversion rules, operators); Data Definition Language (DDL) and Data Manipulation Language (DML); common language elements (constraints, storage clause, predicates); SQL functions; PL/SQL (including procedures, functions, and packages); SQL*Plus, and Oracle SQL optimization and tuning. The book covers Oracle 8i, release 8.1.6.
Synopsis
SQL (Structured Query Language), the heart of a relational database management system, is the language used to query the database, to create new tables in the database, to update and delete fields, and to set access privileges. Aimed at everyone who needs to access an Oracle database using SQL, including developers, DBAs, designers, and managers, this book delivers all the information they need to know about standard SQL, and Oracle's extensions to it.
Synopsis
There are chapters on basic SQL elements (naming requirements, column types, pseudo-types, data conversion rules, operators); Data Definition Language (DDL) and Data Manipulation Language (DML); common language elements (constraints, storage clause, predicates); SQL functions; PL/SQL (including procedures, functions, and packages); SQL*Plus, and Oracle SQL optimization and tuning. The book covers Oracle 8i, release 8.1.6.
About the Author
David Kreines is the Manager of Database Services for Rhodia, Inc., and author of Oracle SQL: The Essential Reference (O'Reilly Media, Inc., 2000) and coauthor of Oracle in a Nutshell (with Rick Greenwald) (O'Reilly Media, Inc., 2002), Oracle Database Administration: The Essential Reference (with Brian Laskey) (O'Reilly Media, Inc., 1999) and Oracle Scripts (with Brian Lomasky) (O'Reilly Media, Inc., 1998). Dave has worked with Oracle as a developer and database administrator since 1985, on a wide variety of platforms, from PCs to mainframes. He is an Oracle Certified Professional, is certified as a DBA, and has been a frequent contributor to Oracle conferences, user groups, and publications, both in the United States and in Europe. Dave served two terms as president of the International Oracle Users Group -Americas (IOUG-A), and spent ten years on the board of directors.
Table of Contents
Dedication; Foreword; SQL: A Venerable History and a Vital Future; Programming and Data Access Languages; The Origins of SQL; The SQL Language; The Commercial Development of SQL through the 1980s; The Evolution of SQL: the 1990s and Beyond; Standardization of the SQL Language; SQL: A Success Story; Preface; Audience for This Book; Versions of Oracle; Contents of This Book; Conventions Used in This Book; Comments and Questions; Acknowledgments; Chapter 1: Elements of SQL; 1.1 Lexical Conventions; 1.2 Naming in SQL; 1.3 Schema Objects; 1.4 Datatypes; 1.5 Data Conversion; 1.6 Relational Operators; 1.7 Structure of a SQL Statement; 1.8 SQL Statements; Chapter 2: Data Definition Statements; 2.1 SQL DDL Statements by Task; 2.2 SQL Statement Syntax; Chapter 3: Data Manipulation and Control Statements; 3.1 SQL DML and Control Statements by Task; 3.2 SQL Statement Syntax; Chapter 4: Common SQL Elements; Chapter 5: SQL Functions; 5.1 Aggregate Functions; 5.2 Numeric Functions; 5.3 Character Functions; 5.4 Date Functions; 5.5 Conversion Functions; 5.6 Other Functions; Chapter 6: SQL*Plus; 6.1 Command-Line Syntax; 6.2 SQL*Plus Editing Commands; 6.3 Formatting SQL*Plus Output; 6.4 Miscellaneous SQL*Plus Commands; 6.5 SQL*Plus Variables and Related Commands; 6.6 SQL*Plus System Variables; Chapter 7: PL/SQL; 7.1 The Structure of PL/SQL; 7.2 Block Header; 7.3 Declaration Section; 7.4 Execution Section; 7.5 ; 7.6 Exception Section; 7.7 Procedures and Packages; 7.8 Triggers; Chapter 8: SQL Statement Tuning; 8.1 Using EXPLAIN PLAN; 8.2 Using Oracle's SQL Trace Facility; 8.3 SQL*Plus Tuning Aids; 8.4 Improving Query Performance; SQL Resources; Books; Other Publications; Organizations; Web Sites; Colophon;