Professional Oracle programming:
Gespeichert in:
| Format: | Elektronisch E-Book |
|---|---|
| Sprache: | English |
| Veröffentlicht: |
Indianapolis, Ind.
Wiley Pub.
c2005
|
| Schriftenreihe: | Wrox professional guides
|
| Schlagworte: | |
| Online-Zugang: | FAW01 FAW02 Volltext |
| Beschreibung: | "Programmer to programmer"--Cover. - Includes index Cover About the Authors Acknowledgments Contents Introduction Introduction What Does This Book Cover? Who Is This Book For? What You Need to Use This Book How Is This Book Structured? The Bigger Picture Conventions Source Code Errata p2p.wrox.com Chapter 1: Oracle Architecture and Storage Architecture Data Types Summary Chapter 2: Using SQL The Processing Cycle for SQL Statements Performance Considerations Summary Chapter 3: Handling Multiple Users Goals Transactions Concurrent User Integrity Problems Locks Contention The Oracle Solution Implementation Issues Summary Chapter 4: Database Design Basics Database Design Phases Database Design Case Study Example Normalization Defining Additional Entities (Tables) Denormalization Other Physical Design Options Object-Oriented Design Options of Oracle Summary Chapter 5: Oracle Security Security Concepts Authentication Authorization Access Control Accountability Enterprise Security Security Practices Summary Chapter 6: The Oracle Data - Dictionary What Is the Data Dictionary? Structure of the Oracle Data Dictionary The Oracle Data Dictionary During Development The Oracle Data Dictionary at Execution Time Summary Chapter 7: Installing Oracle Getting Oracle Software Installing Oracle Server Software Accessing Your Oracle Database Installing Oracle Client Software Summary Chapter 8: Introduction to SQL A Bit of History Standards SQL Statement Groupings Data Definition Language (DDL) Data Manipulation Language (DML) SQL: Set-Orientated and Nonprocedural Summary Chapter 9: Extended SQL Extended Conditions Extended Set Operations MERGE TRUNCATE ROWNUM and Ranking Flashback Query Returning Data from Write Operations Additional Extensions Summary Chapter 10: Indexes Index Basics B-Tree Indexes Reverse Key Indexes Function-Based Indexes Domain Indexes Bitmap Indexes Bitmap Join Index Index-Organized Tables Index Clusters Hash Cluster Design and Performance Tips Summary Chapter 11: Constraints Database Integrity Features Types - of Constraints Working with Constraints Summary Chapter 12: Other Database Structures Tablespaces Compression Partitioning Views Materialized Views Sequences Global Temporary Tables Recycle Bin Synonyms Database Links Advanced Queuing and Streams Objects Stored Procedures, Functions, and Triggers Accessing Flat Files SGA Buffer Pool Assignments Workflows Workspace Manager Summary Chapter 13: Functions What Is a Function? Defining Your Own Functions Oracles Built-In SQL Functions Summary Chapter 14: Distributed Queries, Transactions, - and Databases Linking Distributed Oracle Databases Distributed Transactions and Two-Phase Commit Heterogeneous Services Summary Chapter 15: PL/SQL Basics Code Architecture PL/SQL Language Implementing Logic Creating a PL/SQL Program Using PL/SQL Code Security Native Compilation Uses of PL/SQL Units Summary Chapter 16: PL/SQL and SQL Basic SQL in PL/SQL Cursors Using a Single Cursor Special Data Types FOR Cursor Implicit Cursors REF CURSORs PL/SQL Records and Collections BULK COLLECT FORALL Dynamic SQL Summary Chapter 17: PL/SQL Packages What Is a Package? Impact of Packages An Example Using Packages Together Summary Chapter 18: Introduction to Java Database Programming Java Architecture Oracles Java Architecture Building Sample Applications Summary Chapter 19: Triggers What Are Triggers? Working with Triggers Special Circumstances Triggers in Other Languages Triggers and Mutating Tables Removing Triggers Viewing Triggers in the Data Dictionary Limitations of Triggers Summary Chapter - 20: Regular Expressions and Expression Filter Regular Expressions Expression Filter Summary Chapter 21: Object Relational Interactions with Oracle Object Relational Introducing Oracle Objects Using Oracle Object Types Object Views on Relational Data Oracle JPublisher (JPub) Summary Chapter 22: Oracle XML DB Over |
| Beschreibung: | 1 Online-Ressource (xxxii, 758 p.) |
| ISBN: | 0764574825 0764598732 9780764574825 9780764598739 |
Internformat
MARC
| LEADER | 00000nmm a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV043154091 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 151126s2005 |||| o||u| ||||||eng d | ||
| 020 | |a 0764574825 |c paper/website |9 0-7645-7482-5 | ||
| 020 | |a 0764598732 |c electronic bk. |9 0-7645-9873-2 | ||
| 020 | |a 9780764574825 |c paper/website |9 978-0-7645-7482-5 | ||
| 020 | |a 9780764598739 |c electronic bk. |9 978-0-7645-9873-9 | ||
| 035 | |a (OCoLC)70720194 | ||
| 035 | |a (DE-599)BVBBV043154091 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-1046 |a DE-1047 | ||
| 082 | 0 | |a 005.75/85 |2 22 | |
| 245 | 1 | 0 | |a Professional Oracle programming |c Rick Greenwald ... [et al.] |
| 264 | 1 | |a Indianapolis, Ind. |b Wiley Pub. |c c2005 | |
| 300 | |a 1 Online-Ressource (xxxii, 758 p.) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 490 | 0 | |a Wrox professional guides | |
| 500 | |a "Programmer to programmer"--Cover. - Includes index | ||
| 500 | |a Cover About the Authors Acknowledgments Contents Introduction Introduction What Does This Book Cover? Who Is This Book For? What You Need to Use This Book How Is This Book Structured? The Bigger Picture Conventions Source Code Errata p2p.wrox.com Chapter 1: Oracle Architecture and Storage Architecture Data Types Summary Chapter 2: Using SQL The Processing Cycle for SQL Statements Performance Considerations Summary Chapter 3: Handling Multiple Users Goals Transactions Concurrent User Integrity Problems Locks Contention The Oracle Solution Implementation Issues Summary Chapter 4: Database Design Basics Database Design Phases Database Design Case Study Example Normalization Defining Additional Entities (Tables) Denormalization Other Physical Design Options Object-Oriented Design Options of Oracle Summary Chapter 5: Oracle Security Security Concepts Authentication Authorization Access Control Accountability Enterprise Security Security Practices Summary Chapter 6: The Oracle Data | ||
| 500 | |a - Dictionary What Is the Data Dictionary? Structure of the Oracle Data Dictionary The Oracle Data Dictionary During Development The Oracle Data Dictionary at Execution Time Summary Chapter 7: Installing Oracle Getting Oracle Software Installing Oracle Server Software Accessing Your Oracle Database Installing Oracle Client Software Summary Chapter 8: Introduction to SQL A Bit of History Standards SQL Statement Groupings Data Definition Language (DDL) Data Manipulation Language (DML) SQL: Set-Orientated and Nonprocedural Summary Chapter 9: Extended SQL Extended Conditions Extended Set Operations MERGE TRUNCATE ROWNUM and Ranking Flashback Query Returning Data from Write Operations Additional Extensions Summary Chapter 10: Indexes Index Basics B-Tree Indexes Reverse Key Indexes Function-Based Indexes Domain Indexes Bitmap Indexes Bitmap Join Index Index-Organized Tables Index Clusters Hash Cluster Design and Performance Tips Summary Chapter 11: Constraints Database Integrity Features Types | ||
| 500 | |a - of Constraints Working with Constraints Summary Chapter 12: Other Database Structures Tablespaces Compression Partitioning Views Materialized Views Sequences Global Temporary Tables Recycle Bin Synonyms Database Links Advanced Queuing and Streams Objects Stored Procedures, Functions, and Triggers Accessing Flat Files SGA Buffer Pool Assignments Workflows Workspace Manager Summary Chapter 13: Functions What Is a Function? Defining Your Own Functions Oracles Built-In SQL Functions Summary Chapter 14: Distributed Queries, Transactions, | ||
| 500 | |a - and Databases Linking Distributed Oracle Databases Distributed Transactions and Two-Phase Commit Heterogeneous Services Summary Chapter 15: PL/SQL Basics Code Architecture PL/SQL Language Implementing Logic Creating a PL/SQL Program Using PL/SQL Code Security Native Compilation Uses of PL/SQL Units Summary Chapter 16: PL/SQL and SQL Basic SQL in PL/SQL Cursors Using a Single Cursor Special Data Types FOR Cursor Implicit Cursors REF CURSORs PL/SQL Records and Collections BULK COLLECT FORALL Dynamic SQL Summary Chapter 17: PL/SQL Packages What Is a Package? Impact of Packages An Example Using Packages Together Summary Chapter 18: Introduction to Java Database Programming Java Architecture Oracles Java Architecture Building Sample Applications Summary Chapter 19: Triggers What Are Triggers? Working with Triggers Special Circumstances Triggers in Other Languages Triggers and Mutating Tables Removing Triggers Viewing Triggers in the Data Dictionary Limitations of Triggers Summary Chapter | ||
| 500 | |a - 20: Regular Expressions and Expression Filter Regular Expressions Expression Filter Summary Chapter 21: Object Relational Interactions with Oracle Object Relational Introducing Oracle Objects Using Oracle Object Types Object Views on Relational Data Oracle JPublisher (JPub) Summary Chapter 22: Oracle XML DB Over | ||
| 630 | 0 | 4 | |a Oracle (Computer file) |
| 650 | 4 | |a Oracle (Logiciel) | |
| 650 | 4 | |a Bases de données relationnelles | |
| 650 | 7 | |a COMPUTERS / Data Processing |2 bisacsh | |
| 650 | 7 | |a Oracle (Computer file) |2 fast | |
| 650 | 7 | |a Relational databases |2 fast | |
| 650 | 4 | |a Oracle (Computer file) | |
| 650 | 4 | |a Relational databases | |
| 650 | 0 | 7 | |a ORACLE |g Datenbanksystem |0 (DE-588)4206222-6 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a ORACLE |g Datenbanksystem |0 (DE-588)4206222-6 |D s |
| 689 | 0 | |8 1\p |5 DE-604 | |
| 700 | 1 | |a Greenwald, Rick |e Sonstige |4 oth | |
| 856 | 4 | 0 | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=133976 |x Aggregator |3 Volltext |
| 912 | |a ZDB-4-EBA | ||
| 999 | |a oai:aleph.bib-bvb.de:BVB01-028578282 | ||
| 883 | 1 | |8 1\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 966 | e | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=133976 |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=133976 |l FAW02 |p ZDB-4-EBA |q FAW_PDA_EBA |x Aggregator |3 Volltext | |
Datensatz im Suchindex
| _version_ | 1804175617280704512 |
|---|---|
| any_adam_object | |
| building | Verbundindex |
| bvnumber | BV043154091 |
| collection | ZDB-4-EBA |
| ctrlnum | (OCoLC)70720194 (DE-599)BVBBV043154091 |
| dewey-full | 005.75/85 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75/85 |
| dewey-search | 005.75/85 |
| dewey-sort | 15.75 285 |
| 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>06099nmm a2200577zc 4500</leader><controlfield tag="001">BV043154091</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">0764574825</subfield><subfield code="c">paper/website</subfield><subfield code="9">0-7645-7482-5</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0764598732</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">0-7645-9873-2</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780764574825</subfield><subfield code="c">paper/website</subfield><subfield code="9">978-0-7645-7482-5</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780764598739</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">978-0-7645-9873-9</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)70720194</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV043154091</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.75/85</subfield><subfield code="2">22</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Professional Oracle programming</subfield><subfield code="c">Rick Greenwald ... [et al.]</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Indianapolis, Ind.</subfield><subfield code="b">Wiley Pub.</subfield><subfield code="c">c2005</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (xxxii, 758 p.)</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="490" ind1="0" ind2=" "><subfield code="a">Wrox professional guides</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">"Programmer to programmer"--Cover. - Includes index</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Cover About the Authors Acknowledgments Contents Introduction Introduction What Does This Book Cover? Who Is This Book For? What You Need to Use This Book How Is This Book Structured? The Bigger Picture Conventions Source Code Errata p2p.wrox.com Chapter 1: Oracle Architecture and Storage Architecture Data Types Summary Chapter 2: Using SQL The Processing Cycle for SQL Statements Performance Considerations Summary Chapter 3: Handling Multiple Users Goals Transactions Concurrent User Integrity Problems Locks Contention The Oracle Solution Implementation Issues Summary Chapter 4: Database Design Basics Database Design Phases Database Design Case Study Example Normalization Defining Additional Entities (Tables) Denormalization Other Physical Design Options Object-Oriented Design Options of Oracle Summary Chapter 5: Oracle Security Security Concepts Authentication Authorization Access Control Accountability Enterprise Security Security Practices Summary Chapter 6: The Oracle Data </subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a"> - Dictionary What Is the Data Dictionary? Structure of the Oracle Data Dictionary The Oracle Data Dictionary During Development The Oracle Data Dictionary at Execution Time Summary Chapter 7: Installing Oracle Getting Oracle Software Installing Oracle Server Software Accessing Your Oracle Database Installing Oracle Client Software Summary Chapter 8: Introduction to SQL A Bit of History Standards SQL Statement Groupings Data Definition Language (DDL) Data Manipulation Language (DML) SQL: Set-Orientated and Nonprocedural Summary Chapter 9: Extended SQL Extended Conditions Extended Set Operations MERGE TRUNCATE ROWNUM and Ranking Flashback Query Returning Data from Write Operations Additional Extensions Summary Chapter 10: Indexes Index Basics B-Tree Indexes Reverse Key Indexes Function-Based Indexes Domain Indexes Bitmap Indexes Bitmap Join Index Index-Organized Tables Index Clusters Hash Cluster Design and Performance Tips Summary Chapter 11: Constraints Database Integrity Features Types </subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a"> - of Constraints Working with Constraints Summary Chapter 12: Other Database Structures Tablespaces Compression Partitioning Views Materialized Views Sequences Global Temporary Tables Recycle Bin Synonyms Database Links Advanced Queuing and Streams Objects Stored Procedures, Functions, and Triggers Accessing Flat Files SGA Buffer Pool Assignments Workflows Workspace Manager Summary Chapter 13: Functions What Is a Function? Defining Your Own Functions Oracles Built-In SQL Functions Summary Chapter 14: Distributed Queries, Transactions, </subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a"> - and Databases Linking Distributed Oracle Databases Distributed Transactions and Two-Phase Commit Heterogeneous Services Summary Chapter 15: PL/SQL Basics Code Architecture PL/SQL Language Implementing Logic Creating a PL/SQL Program Using PL/SQL Code Security Native Compilation Uses of PL/SQL Units Summary Chapter 16: PL/SQL and SQL Basic SQL in PL/SQL Cursors Using a Single Cursor Special Data Types FOR Cursor Implicit Cursors REF CURSORs PL/SQL Records and Collections BULK COLLECT FORALL Dynamic SQL Summary Chapter 17: PL/SQL Packages What Is a Package? Impact of Packages An Example Using Packages Together Summary Chapter 18: Introduction to Java Database Programming Java Architecture Oracles Java Architecture Building Sample Applications Summary Chapter 19: Triggers What Are Triggers? Working with Triggers Special Circumstances Triggers in Other Languages Triggers and Mutating Tables Removing Triggers Viewing Triggers in the Data Dictionary Limitations of Triggers Summary Chapter </subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a"> - 20: Regular Expressions and Expression Filter Regular Expressions Expression Filter Summary Chapter 21: Object Relational Interactions with Oracle Object Relational Introducing Oracle Objects Using Oracle Object Types Object Views on Relational Data Oracle JPublisher (JPub) Summary Chapter 22: Oracle XML DB Over</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Oracle (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Oracle (Logiciel)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Bases de données relationnelles</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Data Processing</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">Relational databases</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Oracle (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Relational databases</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">ORACLE</subfield><subfield code="g">Datenbanksystem</subfield><subfield code="0">(DE-588)4206222-6</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">ORACLE</subfield><subfield code="g">Datenbanksystem</subfield><subfield code="0">(DE-588)4206222-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="8">1\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Greenwald, Rick</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=133976</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-028578282</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">1\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</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=133976</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=133976</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.BV043154091 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-10T07:19:08Z |
| institution | BVB |
| isbn | 0764574825 0764598732 9780764574825 9780764598739 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-028578282 |
| oclc_num | 70720194 |
| open_access_boolean | |
| owner | DE-1046 DE-1047 |
| owner_facet | DE-1046 DE-1047 |
| physical | 1 Online-Ressource (xxxii, 758 p.) |
| psigel | ZDB-4-EBA ZDB-4-EBA FAW_PDA_EBA |
| publishDate | 2005 |
| publishDateSearch | 2005 |
| publishDateSort | 2005 |
| publisher | Wiley Pub. |
| record_format | marc |
| series2 | Wrox professional guides |
| spelling | Professional Oracle programming Rick Greenwald ... [et al.] Indianapolis, Ind. Wiley Pub. c2005 1 Online-Ressource (xxxii, 758 p.) txt rdacontent c rdamedia cr rdacarrier Wrox professional guides "Programmer to programmer"--Cover. - Includes index Cover About the Authors Acknowledgments Contents Introduction Introduction What Does This Book Cover? Who Is This Book For? What You Need to Use This Book How Is This Book Structured? The Bigger Picture Conventions Source Code Errata p2p.wrox.com Chapter 1: Oracle Architecture and Storage Architecture Data Types Summary Chapter 2: Using SQL The Processing Cycle for SQL Statements Performance Considerations Summary Chapter 3: Handling Multiple Users Goals Transactions Concurrent User Integrity Problems Locks Contention The Oracle Solution Implementation Issues Summary Chapter 4: Database Design Basics Database Design Phases Database Design Case Study Example Normalization Defining Additional Entities (Tables) Denormalization Other Physical Design Options Object-Oriented Design Options of Oracle Summary Chapter 5: Oracle Security Security Concepts Authentication Authorization Access Control Accountability Enterprise Security Security Practices Summary Chapter 6: The Oracle Data - Dictionary What Is the Data Dictionary? Structure of the Oracle Data Dictionary The Oracle Data Dictionary During Development The Oracle Data Dictionary at Execution Time Summary Chapter 7: Installing Oracle Getting Oracle Software Installing Oracle Server Software Accessing Your Oracle Database Installing Oracle Client Software Summary Chapter 8: Introduction to SQL A Bit of History Standards SQL Statement Groupings Data Definition Language (DDL) Data Manipulation Language (DML) SQL: Set-Orientated and Nonprocedural Summary Chapter 9: Extended SQL Extended Conditions Extended Set Operations MERGE TRUNCATE ROWNUM and Ranking Flashback Query Returning Data from Write Operations Additional Extensions Summary Chapter 10: Indexes Index Basics B-Tree Indexes Reverse Key Indexes Function-Based Indexes Domain Indexes Bitmap Indexes Bitmap Join Index Index-Organized Tables Index Clusters Hash Cluster Design and Performance Tips Summary Chapter 11: Constraints Database Integrity Features Types - of Constraints Working with Constraints Summary Chapter 12: Other Database Structures Tablespaces Compression Partitioning Views Materialized Views Sequences Global Temporary Tables Recycle Bin Synonyms Database Links Advanced Queuing and Streams Objects Stored Procedures, Functions, and Triggers Accessing Flat Files SGA Buffer Pool Assignments Workflows Workspace Manager Summary Chapter 13: Functions What Is a Function? Defining Your Own Functions Oracles Built-In SQL Functions Summary Chapter 14: Distributed Queries, Transactions, - and Databases Linking Distributed Oracle Databases Distributed Transactions and Two-Phase Commit Heterogeneous Services Summary Chapter 15: PL/SQL Basics Code Architecture PL/SQL Language Implementing Logic Creating a PL/SQL Program Using PL/SQL Code Security Native Compilation Uses of PL/SQL Units Summary Chapter 16: PL/SQL and SQL Basic SQL in PL/SQL Cursors Using a Single Cursor Special Data Types FOR Cursor Implicit Cursors REF CURSORs PL/SQL Records and Collections BULK COLLECT FORALL Dynamic SQL Summary Chapter 17: PL/SQL Packages What Is a Package? Impact of Packages An Example Using Packages Together Summary Chapter 18: Introduction to Java Database Programming Java Architecture Oracles Java Architecture Building Sample Applications Summary Chapter 19: Triggers What Are Triggers? Working with Triggers Special Circumstances Triggers in Other Languages Triggers and Mutating Tables Removing Triggers Viewing Triggers in the Data Dictionary Limitations of Triggers Summary Chapter - 20: Regular Expressions and Expression Filter Regular Expressions Expression Filter Summary Chapter 21: Object Relational Interactions with Oracle Object Relational Introducing Oracle Objects Using Oracle Object Types Object Views on Relational Data Oracle JPublisher (JPub) Summary Chapter 22: Oracle XML DB Over Oracle (Computer file) Oracle (Logiciel) Bases de données relationnelles COMPUTERS / Data Processing bisacsh Oracle (Computer file) fast Relational databases fast Relational databases ORACLE Datenbanksystem (DE-588)4206222-6 gnd rswk-swf ORACLE Datenbanksystem (DE-588)4206222-6 s 1\p DE-604 Greenwald, Rick Sonstige oth http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=133976 Aggregator Volltext 1\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk |
| spellingShingle | Professional Oracle programming Oracle (Computer file) Oracle (Logiciel) Bases de données relationnelles COMPUTERS / Data Processing bisacsh Oracle (Computer file) fast Relational databases fast Relational databases ORACLE Datenbanksystem (DE-588)4206222-6 gnd |
| subject_GND | (DE-588)4206222-6 |
| title | Professional Oracle programming |
| title_auth | Professional Oracle programming |
| title_exact_search | Professional Oracle programming |
| title_full | Professional Oracle programming Rick Greenwald ... [et al.] |
| title_fullStr | Professional Oracle programming Rick Greenwald ... [et al.] |
| title_full_unstemmed | Professional Oracle programming Rick Greenwald ... [et al.] |
| title_short | Professional Oracle programming |
| title_sort | professional oracle programming |
| topic | Oracle (Computer file) Oracle (Logiciel) Bases de données relationnelles COMPUTERS / Data Processing bisacsh Oracle (Computer file) fast Relational databases fast Relational databases ORACLE Datenbanksystem (DE-588)4206222-6 gnd |
| topic_facet | Oracle (Computer file) Oracle (Logiciel) Bases de données relationnelles COMPUTERS / Data Processing Relational databases ORACLE Datenbanksystem |
| url | http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=133976 |
| work_keys_str_mv | AT greenwaldrick professionaloracleprogramming |