Oracle SQL- Jumpstart with Examples, Elsevier

Team DDU......Page 1 Table of Contents......Page 8 Foreword......Page 20 Preface......Page 22 Acknowledgements......Page 30 1 Introduction to Oracle SQL......Page 32 2 New Features of Oracle SQL......Page 70 3 Oracle Database Architecture......Page 82 4 The SELECT Statement......Page 104 5 Filtering Rows......Page 128 6 Sorting Rows......Page 140 7 Operators, Conditions, and Pseudocolumns......Page 154 8 Using SQL*Plus......Page 168 9 Single-Row Functions......Page 206 10 Joining Tables......Page 236 11 Grouping and Summarizing Data......Page 266 12 Subqueries......Page 298 13 Unusual Query Types......Page 316 14 Expressions......Page 332 15 Data Manipulation Language (DML)......Page 346 16 Datatypes and Collections......Page 370 17 XML in Oracle......Page 388 18 Tables......Page 414 19 Views......Page 456 20 Constraints......Page 478 21 Indexes and Clusters......Page 502 22 Sequences and Synonyms......Page 520 23 Security......Page 534 24 Basic PL/SQL......Page 562 Appendix A......Page 600 Appendix B......Page 654 Appendix C......Page 656 Index......Page 658 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 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 Developers and DBAs use Oracle SQL coding on a daily basis, whether for application development, finding problems, finetuning 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 tables, views and indexes, Oracle Partitioning, security, and finally PL/SQL. For the quickest solutions to any knotty coding problem, a complete Oracle SQL reference