Oracle SQL: The Essential Reference - Brossura

Kreines, David C.

 
9781565926974: Oracle SQL: The Essential Reference
Brossura
ISBN 10: 1565926978 ISBN 13: 9781565926974
Casa editrice: O'Reilly Media, 2000

Sinossi

Deals with using structured query language (SQL) to access an Oracle8i database. The author surveys SQL statements for definition or modification of database objects and for data manipulation and control, commands for the SQL*Plus interface, and structure and syntax for the basic elements of procedural language extensions to SQL (PL/SQL). Annotation c. Book News, Inc., Portland, OR (booknews.com)

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

Contenuti

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;

Product Description

Book by Kreines David C

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

Editore
O'Reilly Media
Data di pubblicazione
2000
Lingua
Inglese
ISBN 10 
1565926978
ISBN 13 
9781565926974
Rilegatura
Copertina flessibile
Numero edizione
1
Numero di pagine
500
Contatto del produttore
non disponibile
Persona responsabile
non disponibile