Professional Oracle programming / Rick Greenwald ... [et al.].

Format:

Book

Contributor:

Greenwald, Rick.

Series:

Wrox professional guides.

Wrox professional guides

Language:

English

Subjects (All):

Relational databases.

Oracle (Computer file).

Physical Description:

1 online resource (792 p.)

Edition:

1st ed.

Place of Publication:

Indianapolis, Ind. : Wiley Pub., c2005.

Language Note:

English

Summary:

One of the only Oracle books to focus exclusively on database programming rather than administrationOracle owns sixty percent of the commercial database marketProvides full coverage of the latest Oracle version, 10g-including new features such as regular expressions and the MODEL SQL clause-as well as versions 8, 8i, and 9iThe authors are well-known as Oracle gurus-Greenwald is the author of Oracle in a Nutshell and the coauthor, with Stackowiak, of Oracle 9 EssentialsShows how to use Oracle data and data structures to build robust, scalable database applications using

Contents:

Professional Oracle Programming; 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 IssuesSummary; 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 TimeSummary; 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 ExtensionsSummary; 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 TriggersAccessing Flat Files; SGA Buffer Pool Assignments; Workflows; Workspace Manager; Summary; Chapter 13: Functions; What Is a Function?; Defining Your Own Functions; Oracle's 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

Notes:

"Programmer to programmer"--Cover.

Includes index.

ISBN:

1-280-27916-8

9786610279166

0-7645-9873-2

OCLC:

70720194