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)

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;

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

Descrizione libreria

We offer a wide variety of books including fiction and non-fiction titles.

Visita la pagina della libreria

Informazioni sull?azienda del venditore

SBYB, Inc.
900 Knell Rd, Montgomery, IL, 60538, U.S.A.

Condizioni di vendita e spedizione

Condizioni di vendita

We guarantee the condition of every book as it's described on the Abebooks web sites. If you're dissatisfied with your purchase (Incorrect Book/Not as Described/Damaged) or if the order hasn't arrived, you're eligible for a refund within 30 days of the estimated delivery date. If you've changed your mind about a book that you've ordered, please use the Ask bookseller a question link to contact us and we'll respond within 2 business days.

Diritto di recesso

Condizioni di spedizione

Shipping costs are based on books weighing 2.2 LB, or 1 KG. If your book order is heavy or oversized, we may contact you to let you know extra shipping is required.

Tariffe di spedizione da U.S.A. a Italia

Tariffe di spedizione da U.S.A. a Italia
Quantit� dell?ordine	Da 7 a 21 giorni lavorativi	Da 7 a 21 giorni lavorativi
Primo articolo	EUR 30.01	EUR 30.01

I tempi di consegna sono stabiliti dai venditori e variano in base al corriere e al paese. Gli ordini che devono attraversare una dogana possono subire ritardi e spetta agli acquirenti pagare eventuali tariffe o dazi associati. I venditori possono contattarti in merito ad addebiti aggiuntivi dovuti a eventuali maggiorazioni dei costi di spedizione dei tuoi articoli.