Oracle SQL - The Essential Reference - David C. Kreines - Librairie Eyrolles

Déjà client ? Identifiez-vous

Mot de passe oublié ?

Nouveau client ?

CRÉER VOTRE COMPTE
Oracle SQL
Ajouter à une liste

Librairie Eyrolles - Paris 5e
Indisponible

Oracle SQL

Oracle SQL

The Essential Reference

David C. Kreines

424 pages, parution le 15/11/2000

Résumé

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.


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

Livraison à partir de 0,01 en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
satisfait ou remboursé
Satisfait ou remboursé
Paiement sécurisé
modes de paiement
Paiement à l'expédition
partout dans le monde
Livraison partout dans le monde
Service clients sav@commande.eyrolles.com
librairie française
Librairie française depuis 1925
Recevez nos newsletters
Vous serez régulièrement informé(e) de toutes nos actualités.
Inscription