Online Public Access Catalogue (OPAC)
Library,Documentation and Information Science Division

“A research journal serves that narrow

borderland which separates the known from the unknown”

-P.C.Mahalanobis


Normal view MARC view ISBD view

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

Contributor(s): Greenwald, Rick.
Material type: TextTextSeries: Wrox professional guides: Publisher: Indianapolis, Ind. : Wiley Pub., c2005Description: 1 online resource (xxxii, 758 p.) : ill.ISBN: 0764574825 (paper/website); 9780764574825 (paper/website); 0764598732 (electronic bk.); 9780764598739 (electronic bk.).Subject(s): Oracle (Computer file) | Relational databases | Oracle (Logiciel) | Bases de donn�ees relationnelles | COMPUTERS -- Data ProcessingGenre/Form: Electronic books.Additional physical formats: Print version:: Professional Oracle programming.DDC classification: 005.75/85 Online resources: EBSCOhost
Contents:
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.
Tags from this library: No tags from this library for this title. Log in to add tags.
No physical items for this record

"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.

Description based on print version record.

There are no comments for this item.

Log in to your account to post a comment.

Other editions of this work

Professional Oracle programming ©2005
Library, Documentation and Information Science Division, Indian Statistical Institute, 203 B T Road, Kolkata 700108, INDIA
Phone no. 91-33-2575 2100, Fax no. 91-33-2578 1412, ksatpathy@isical.ac.in


Visitor Counter