Résumé
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.
Contents
Foreword
Preface
1. Elements of SQL
Lexical Conventions
Naming in SQL
Schema Objects
Datatypes
Data Conversion
Relational Operators
Structure of a SQL Statement
SQL Statements
2. Data Definition Statements
SQL DDL Statements by Task
SQL Statement Syntax
3. Data Manipulation and Control Statements
SQL DML and Control Statements by Task
SQL Statement Syntax
4. Common SQL Elements
5. SQL Functions
Aggregate Functions
Numeric Functions
Character Functions
Date Functions
Conversion Functions
Other Functions
6. SQL*Plus
Command-Line Syntax
SQL*Plus Editing Commands
Formatting SQL*Plus Output
Miscellaneous SQL*Plus Commands
SQL*Plus Variables and Related Commands
SQL*Plus System Variables
7. PL/SQL
The Structure of PL/SQL
Block Header
Declaration Section
Execution Section
Exception Section
Procedures and Packages
Triggers
8. SQL Statement Tuning
Using EXPLAIN PLAN
Using Oracle's SQL Trace Facility
SQL*Plus Tuning Aids
Improving Query Performance
A. SQL Resources
Index
L'auteur - David C. Kreines
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.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | O'Reilly |
| Auteur(s) | David C. Kreines |
| Parution | 15/11/2000 |
| Nb. de pages | 424 |
| Format | 17,7 x 23,3 |
| Couverture | Broché |
| Poids | 690g |
| Intérieur | Noir et Blanc |
| EAN13 | 9781565926974 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
