Detalles del Título
Detalles del Título

< Ant.
Sig. >
 
Título Oracle SQL: Jumpstart with examples / Gavin Powell, Carol McCullough-DieterLibros / Disco comp. - Libros
Autor(es) Powell, Gavin (Autor)
McCullough-Dieter, Carol (Autor)
Publicación Amsterdam, Netherlands : Elsevier Digital Press, ©2005 ; Boston, Massachusetts
Descripción Física 1 online resource (xxix, 652 pages) : illustrations
Idioma Inglés;
ISBN 9781417549764 (electronic bk.)
9781555583231
9780080479835
Clasificación(es) QA76.73.S67P62 2005
Materia(s) SQL (Computer program language); COMPUTERS - Programming Languages - C¿; COMPUTERS - Programming Languages - Java; COMPUTERS - Programming Languages - Pascal; SQL (Computer program language); ;
Nota(s) Developers and DBAs use Oracle SQL coding on a daily basis, whether for application development, finding problems, fine-tuning solutions to those problems, or other critical DBA tasks. Oracle SQL: Jumpstart with Examples is the fastest way to get started and to quickly locate answers to common (and uncommon) questions. It includes all the basic queries: filtering, sorting, operators, conditionals, pseudocolumns, single row functions, joins, grouping and summarizing, grouping functions, subqueries, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions, DML, datatypes (including collections), XML in Oracle, DDL for basic database objects such as tales, views and indexes, Oracle Partitioning, security, and finally PL/SQL. * Each of the hundreds of SQL code examples was tested on a working Oracle 10g database * Invaluable everyday tool that provides an absolute plethora of properly tested examples of Oracle SQL code * Authors have four decades of commercial experience between them as developers and database administrators
Includes bibliographical references and index
Cover -- Table of Contents -- Foreword -- Preface -- Acknowledgements -- Chapter 1. Introduction to Oracle SQL -- 1.1 A Little History -- 1.2 The Basics of Relational Data Modeling -- 1.3 Structured Query Language (SQL) -- 1.4 Software Useful for Reading this Book -- 1.5 Syntax Conventions Used in This Book -- 1.6 SQL Tools -- 1.7 The MUSIC Schema -- Chapter 2. New Features of Oracle SQL -- 2.1 New Features in Oracle Database 10g -- 2.2 New Features in Oracle Database 9i -- Chapter 3. Oracle Database Architecture -- 3.1 The Basic Concepts -- 3.2 The Oracle Instance -- 3.3 Oracle Database Physical Architecture -- 3.4 Database Startup and Shutdown -- 3.5 Enhancing the Physical Architecture -- Chapter 4. The SELECT Statement -- 4.1 The Basic SELECT Statement -- 4.2 Types of SELECT Queries -- 4.3 Other Aspects of the SELECT Statement -- Chapter 5. Filtering Rows -- 5.1 WHERE Clause Syntax -- 5.2 WHERE Clause Expression Conditions -- 5.3 Logical Operators in the WHERE Clause -- 5.4 Top-N Queries -- Chapter 6. Sorting Rows -- 6.1 ORDER BY Clause Syntax -- 6.2 Sorting and Null Values -- 6.3 Sorting Methods -- Chapter 7. Operators, Conditions, and Pseudocolumns -- 7.1 Precedence -- 7.2 Operators -- 7.3 Conditions -- 7.4 Pseudocolumns -- Chapter 8. Using SQL*Plus -- 8.1 Environmental Settings -- 8.2 Using Scripts and Variables -- 8.3 Formatting Query Output in SQL*Plus -- 8.4 Using iSQL*Plus -- Chapter 9. Single-Row Functions -- 9.1 Types of Functions -- 9.2 Single-Row Functions -- 9.3 Combining Functions -- Chapter 10. Joining Tables -- 10.1 Join Formats -- 10.2 Types of Joins -- 10.3 Examining Different Types of Joins -- Chapter 11. Grouping and Summarizing Data -- 11.1 GROUP BY Clause Syntax -- 11.2 Types of Group Functions -- 11.3 Special Grouping Function Behavior -- 11.4 Using the GROUP BY Clause -- 11.5 10g The SPREADSHEET (MODEL) Clause -- Chapter 12. Subqueries -- 12.1 Types of Subqueries -- 12.2 Where Can Subqueries Be Used? -- 12.3 Comparison Conditions and Subque
Objetos Asociados Consulta en línea
Ver en WorldCat WorldCat
Ver en Google Books Google Books