Oracle SQL: Jumpstart with examples
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Amsterdam
Elsevier Digital Press
©2005
|
| Schlagworte: | |
| Online-Zugang: | FAW01 FAW02 Volltext |
| Beschreibung: | 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 Subqueries -- 12.4 Demonstrating Subqueries -- Chapter 13. Unusual Query Types -- 13.1 Composite Queries -- 13.2 Hierarchical Queries -- 13.3 Flashback and Versions Queries -- 13.4 Parallel Queries -- Chapter 14. Expressions -- 14.1 Types of Expressions -- 14.2 10g Regular Expressions -- 14.3 10g Oracle Expression Filter -- Chapter 15. Data Manipulation Language (DML) -- 15.1 What Is DML? -- 15.2 Transaction Control -- 15.3 Adding Data (INSERT) -- 15.4 Changing Data (UPDATE) -- 15.5 Deleting Data (DELETE) -- 15.6 10g Merging New and Old Data (MERGE) -- Chapter 16. Datatypes and Collections -- 16.1 Simple Datatypes -- 16.2 Complex and Object Datatypes -- 16.3 Special Datatypes -- Chapter 17. XML in Oracle -- 17.1 What Is XML? -- 17.2 Using XM. 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 |
| Beschreibung: | 1 Online-Ressource (xxix, 652 pages) |
| ISBN: | 0080479839 1417549769 1555583237 9780080479835 9781417549764 9781555583231 |
Internformat
MARC
| LEADER | 00000nmm a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV043098203 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 151126s2005 |||| o||u| ||||||eng d | ||
| 020 | |a 0080479839 |9 0-08-047983-9 | ||
| 020 | |a 1417549769 |9 1-4175-4976-9 | ||
| 020 | |a 1555583237 |9 1-55558-323-7 | ||
| 020 | |a 9780080479835 |9 978-0-08-047983-5 | ||
| 020 | |a 9781417549764 |9 978-1-4175-4976-4 | ||
| 020 | |a 9781555583231 |9 978-1-55558-323-1 | ||
| 035 | |a (OCoLC)56837422 | ||
| 035 | |a (DE-599)BVBBV043098203 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-1046 |a DE-1047 | ||
| 082 | 0 | |a 005.133 |2 22 | |
| 100 | 1 | |a Powell, Gavin |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Oracle SQL |b Jumpstart with examples |c Gavin Powell, Carol McCullough-Dieter |
| 264 | 1 | |a Amsterdam |b Elsevier Digital Press |c ©2005 | |
| 300 | |a 1 Online-Ressource (xxix, 652 pages) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 500 | |a Includes bibliographical references and index | ||
| 500 | |a 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 -- | ||
| 500 | |a - 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? -- | ||
| 500 | |a - 12.3 Comparison Conditions and Subqueries -- 12.4 Demonstrating Subqueries -- Chapter 13. Unusual Query Types -- 13.1 Composite Queries -- 13.2 Hierarchical Queries -- 13.3 Flashback and Versions Queries -- 13.4 Parallel Queries -- Chapter 14. Expressions -- 14.1 Types of Expressions -- 14.2 10g Regular Expressions -- 14.3 10g Oracle Expression Filter -- Chapter 15. Data Manipulation Language (DML) -- 15.1 What Is DML? -- 15.2 Transaction Control -- 15.3 Adding Data (INSERT) -- 15.4 Changing Data (UPDATE) -- 15.5 Deleting Data (DELETE) -- 15.6 10g Merging New and Old Data (MERGE) -- Chapter 16. Datatypes and Collections -- 16.1 Simple Datatypes -- 16.2 Complex and Object Datatypes -- 16.3 Special Datatypes -- Chapter 17. XML in Oracle -- 17.1 What Is XML? -- 17.2 Using XM. | ||
| 500 | |a 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 | ||
| 630 | 0 | 4 | |a Oracle (Computer file) |
| 650 | 7 | |a COMPUTERS / Programming Languages / C♯ |2 bisacsh | |
| 650 | 7 | |a COMPUTERS / Programming Languages / Java |2 bisacsh | |
| 650 | 7 | |a COMPUTERS / Programming Languages / Pascal |2 bisacsh | |
| 650 | 7 | |a Oracle (Computer file) |2 fast | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 650 | 4 | |a SQL (Computer program language) | |
| 700 | 1 | |a McCullough-Dieter, Carol |e Sonstige |4 oth | |
| 856 | 4 | 0 | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=117183 |x Aggregator |3 Volltext |
| 912 | |a ZDB-4-EBA | ||
| 999 | |a oai:aleph.bib-bvb.de:BVB01-028522394 | ||
| 966 | e | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=117183 |l FAW01 |p ZDB-4-EBA |q FAW_PDA_EBA |x Aggregator |3 Volltext | |
| 966 | e | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=117183 |l FAW02 |p ZDB-4-EBA |q FAW_PDA_EBA |x Aggregator |3 Volltext | |
Datensatz im Suchindex
| _version_ | 1804175505493065728 |
|---|---|
| any_adam_object | |
| author | Powell, Gavin |
| author_facet | Powell, Gavin |
| author_role | aut |
| author_sort | Powell, Gavin |
| author_variant | g p gp |
| building | Verbundindex |
| bvnumber | BV043098203 |
| collection | ZDB-4-EBA |
| ctrlnum | (OCoLC)56837422 (DE-599)BVBBV043098203 |
| dewey-full | 005.133 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.133 |
| dewey-search | 005.133 |
| dewey-sort | 15.133 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>05913nmm a2200529zc 4500</leader><controlfield tag="001">BV043098203</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">151126s2005 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0080479839</subfield><subfield code="9">0-08-047983-9</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1417549769</subfield><subfield code="9">1-4175-4976-9</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1555583237</subfield><subfield code="9">1-55558-323-7</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780080479835</subfield><subfield code="9">978-0-08-047983-5</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781417549764</subfield><subfield code="9">978-1-4175-4976-4</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781555583231</subfield><subfield code="9">978-1-55558-323-1</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)56837422</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV043098203</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-1046</subfield><subfield code="a">DE-1047</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.133</subfield><subfield code="2">22</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Powell, Gavin</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Oracle SQL</subfield><subfield code="b">Jumpstart with examples</subfield><subfield code="c">Gavin Powell, Carol McCullough-Dieter</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Amsterdam</subfield><subfield code="b">Elsevier Digital Press</subfield><subfield code="c">©2005</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (xxix, 652 pages)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes bibliographical references and index</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">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 -- </subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a"> - 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? -- </subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a"> - 12.3 Comparison Conditions and Subqueries -- 12.4 Demonstrating Subqueries -- Chapter 13. Unusual Query Types -- 13.1 Composite Queries -- 13.2 Hierarchical Queries -- 13.3 Flashback and Versions Queries -- 13.4 Parallel Queries -- Chapter 14. Expressions -- 14.1 Types of Expressions -- 14.2 10g Regular Expressions -- 14.3 10g Oracle Expression Filter -- Chapter 15. Data Manipulation Language (DML) -- 15.1 What Is DML? -- 15.2 Transaction Control -- 15.3 Adding Data (INSERT) -- 15.4 Changing Data (UPDATE) -- 15.5 Deleting Data (DELETE) -- 15.6 10g Merging New and Old Data (MERGE) -- Chapter 16. Datatypes and Collections -- 16.1 Simple Datatypes -- 16.2 Complex and Object Datatypes -- 16.3 Special Datatypes -- Chapter 17. XML in Oracle -- 17.1 What Is XML? -- 17.2 Using XM.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">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</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Oracle (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Programming Languages / C♯</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Programming Languages / Java</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Programming Languages / Pascal</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Oracle (Computer file)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">SQL (Computer program language)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL (Computer program language)</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">McCullough-Dieter, Carol</subfield><subfield code="e">Sonstige</subfield><subfield code="4">oth</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=117183</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-028522394</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=117183</subfield><subfield code="l">FAW01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FAW_PDA_EBA</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=117183</subfield><subfield code="l">FAW02</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FAW_PDA_EBA</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV043098203 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-10T07:17:21Z |
| institution | BVB |
| isbn | 0080479839 1417549769 1555583237 9780080479835 9781417549764 9781555583231 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-028522394 |
| oclc_num | 56837422 |
| open_access_boolean | |
| owner | DE-1046 DE-1047 |
| owner_facet | DE-1046 DE-1047 |
| physical | 1 Online-Ressource (xxix, 652 pages) |
| psigel | ZDB-4-EBA ZDB-4-EBA FAW_PDA_EBA |
| publishDate | 2005 |
| publishDateSearch | 2005 |
| publishDateSort | 2005 |
| publisher | Elsevier Digital Press |
| record_format | marc |
| spelling | Powell, Gavin Verfasser aut Oracle SQL Jumpstart with examples Gavin Powell, Carol McCullough-Dieter Amsterdam Elsevier Digital Press ©2005 1 Online-Ressource (xxix, 652 pages) txt rdacontent c rdamedia cr rdacarrier 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 Subqueries -- 12.4 Demonstrating Subqueries -- Chapter 13. Unusual Query Types -- 13.1 Composite Queries -- 13.2 Hierarchical Queries -- 13.3 Flashback and Versions Queries -- 13.4 Parallel Queries -- Chapter 14. Expressions -- 14.1 Types of Expressions -- 14.2 10g Regular Expressions -- 14.3 10g Oracle Expression Filter -- Chapter 15. Data Manipulation Language (DML) -- 15.1 What Is DML? -- 15.2 Transaction Control -- 15.3 Adding Data (INSERT) -- 15.4 Changing Data (UPDATE) -- 15.5 Deleting Data (DELETE) -- 15.6 10g Merging New and Old Data (MERGE) -- Chapter 16. Datatypes and Collections -- 16.1 Simple Datatypes -- 16.2 Complex and Object Datatypes -- 16.3 Special Datatypes -- Chapter 17. XML in Oracle -- 17.1 What Is XML? -- 17.2 Using XM. 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 Oracle (Computer file) COMPUTERS / Programming Languages / C♯ bisacsh COMPUTERS / Programming Languages / Java bisacsh COMPUTERS / Programming Languages / Pascal bisacsh Oracle (Computer file) fast SQL (Computer program language) fast SQL (Computer program language) McCullough-Dieter, Carol Sonstige oth http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=117183 Aggregator Volltext |
| spellingShingle | Powell, Gavin Oracle SQL Jumpstart with examples Oracle (Computer file) COMPUTERS / Programming Languages / C♯ bisacsh COMPUTERS / Programming Languages / Java bisacsh COMPUTERS / Programming Languages / Pascal bisacsh Oracle (Computer file) fast SQL (Computer program language) fast SQL (Computer program language) |
| title | Oracle SQL Jumpstart with examples |
| title_auth | Oracle SQL Jumpstart with examples |
| title_exact_search | Oracle SQL Jumpstart with examples |
| title_full | Oracle SQL Jumpstart with examples Gavin Powell, Carol McCullough-Dieter |
| title_fullStr | Oracle SQL Jumpstart with examples Gavin Powell, Carol McCullough-Dieter |
| title_full_unstemmed | Oracle SQL Jumpstart with examples Gavin Powell, Carol McCullough-Dieter |
| title_short | Oracle SQL |
| title_sort | oracle sql jumpstart with examples |
| title_sub | Jumpstart with examples |
| topic | Oracle (Computer file) COMPUTERS / Programming Languages / C♯ bisacsh COMPUTERS / Programming Languages / Java bisacsh COMPUTERS / Programming Languages / Pascal bisacsh Oracle (Computer file) fast SQL (Computer program language) fast SQL (Computer program language) |
| topic_facet | Oracle (Computer file) COMPUTERS / Programming Languages / C♯ COMPUTERS / Programming Languages / Java COMPUTERS / Programming Languages / Pascal SQL (Computer program language) |
| url | http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=117183 |
| work_keys_str_mv | AT powellgavin oraclesqljumpstartwithexamples AT mcculloughdietercarol oraclesqljumpstartwithexamples |