Cover image for Oracle SQL : the essential reference
Oracle SQL : the essential reference
Kreines, David C.
Personal Author:
First edition.
Publication Information:
Cambridge, Mass. : O'Reilly, [2000]

Physical Description:
xxxiii, 382 pages ; 24 cm
Title Subject:
Format :


Call Number
Material Type
Home Location
Item Holds
QA76.73.S67 K74 2000 Adult Non-Fiction Central Closed Stacks

On Order



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 8 i, release 8.1.6.

Table of Contents

Forewordp. ix
Prefacep. xxvii
1. Elements of SQLp. 1
Lexical Conventionsp. 2
Naming in SQLp. 3
Schema Objectsp. 4
Datatypesp. 6
Data Conversionp. 13
Relational Operatorsp. 14
Structure of a SQL Statementp. 20
SQL Statementsp. 24
2. Data Definition Statementsp. 32
SQL DDL Statements by Taskp. 32
SQL Statement Syntaxp. 38
3. Data Manipulation and Control Statementsp. 106
SQL DML and Control Statements by Taskp. 106
SQL Statement Syntaxp. 107
4. Common SQL Elementsp. 133
5. SQL Functionsp. 145
Aggregate Functionsp. 146
Numeric Functionsp. 153
Character Functionsp. 162
Date Functionsp. 174
Conversion Functionsp. 182
Other Functionsp. 190
6. SQL*Plusp. 204
Command-Line Syntaxp. 204
SQL*Plus Editing Commandsp. 208
Formatting SQL*Plus Outputp. 211
Miscellaneous SQL*Plus Commandsp. 221
SQL*Plus Variables and Related Commandsp. 238
SQL*Plus System Variablesp. 241
7. PL/SQLp. 262
The Structure of PL/SQLp. 263
Block Headerp. 265
Declaration Sectionp. 265
Execution Sectionp. 280
Exception Sectionp. 298
Procedures and Packagesp. 304
Triggersp. 318
8. SQL Statement Tuningp. 324
Using EXPLAIN PLANp. 325
Using Oracle's SQL Trace Facilityp. 334
SQL*Plus Tuning Aidsp. 345
Improving Query Performancep. 351
A. SQL Resourcesp. 361
Indexp. 365