Oracle SQL: The Essential Reference - Brossura

Kreines, David C.

Brossura

ISBN 10: 1565926978 ISBN 13: 9781565926974

Casa editrice: O'Reilly Media, 2000

Riassunto

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)

Su questo libro

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

Dettagli dell'edizione

• 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