skip to content
Professional Oracle programming Preview this item
ClosePreview this item

Professional Oracle programming

Author: Rick Greenwald
Publisher: Indianapolis, Ind. : Wiley Pub., ©2005.
Series: Wrox professional guides.
Edition/Format:   eBook : Document : EnglishView all editions and formats

(not yet rated) 0 with reviews - Be the first.

More like this


Find a copy online

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...


Genre/Form: Electronic books
Additional Physical Format: Print version:
Professional Oracle programming.
Indianapolis, Ind. : Wiley Pub., ©2005
(DLC) 2005010511
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Rick Greenwald
ISBN: 0764574825 9780764574825 0764598732 9780764598739
OCLC Number: 70720194
Notes: "Programmer to programmer"--Cover.
Includes index.
Description: 1 online resource (xxxii, 758 pages) : illustrations.
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 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.
Series Title: Wrox professional guides.
Responsibility: Rick Greenwald [and others].


Editorial reviews

Publisher Synopsis

" ... a good book for an introduction to Oracle, but especially good if you are interested in the areas of Business Intelligence, HTML-DB, XML DB and Regular Expressions... " ("OracleHome," 3 August Read more...

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...


Be the first.

Similar Items

Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data

Primary Entity

<> # Professional Oracle programming
    a schema:CreativeWork, schema:Book, schema:MediaObject ;
    library:oclcnum "70720194" ;
    library:placeOfPublication <> ;
    library:placeOfPublication <> ; # Indianapolis, Ind.
    rdfs:comment "Warning: This malformed URI has been treated as a string - '{E70BC296-361F-4C46-AE19-AE2CEE6ABDB6}&Format=50'" ;
    rdfs:comment "Warning: This malformed URI has been treated as a string - '^u'" ;
    schema:about <> ; # Oracle (Logiciel)
    schema:about <> ; # Oracle (Computer file)
    schema:about <> ; # COMPUTERS--Data Processing
    schema:about <> ; # Bases de données relationnelles
    schema:about <> ; # Relational databases
    schema:about <> ;
    schema:about <> ; # Oracle (Computer file)
    schema:bookFormat schema:EBook ;
    schema:contributor <> ; # Rick Greenwald
    schema:copyrightYear "2005" ;
    schema:datePublished "2005" ;
    schema:exampleOfWork <> ;
    schema:genre "Electronic books"@en ;
    schema:inLanguage "en" ;
    schema:isPartOf <> ; # Wrox professional guides.
    schema:isSimilarTo <> ;
    schema:name "Professional Oracle programming"@en ;
    schema:productID "70720194" ;
    schema:publication <> ;
    schema:publisher <> ; # Wiley Pub.
    schema:url <> ;
    schema:url <> ;
    schema:url <> ;
    schema:url <> ;
    schema:url "^u" ;
    schema:url <> ;
    schema:url "{E70BC296-361F-4C46-AE19-AE2CEE6ABDB6}&Format=50" ;
    schema:url <> ;
    schema:workExample <> ;
    schema:workExample <> ;
    wdrs:describedby <> ;

Related Entities

<> # Oracle (Computer file)
    a schema:CreativeWork ;
    schema:name "Oracle (Computer file)" ;

<> # Rick Greenwald
    a schema:Person ;
    schema:familyName "Greenwald" ;
    schema:givenName "Rick" ;
    schema:name "Rick Greenwald" ;

<> # Indianapolis, Ind.
    a schema:Place ;
    schema:name "Indianapolis, Ind." ;

<> # Wrox professional guides.
    a bgn:PublicationSeries ;
    schema:hasPart <> ; # Professional Oracle programming
    schema:name "Wrox professional guides." ;
    schema:name "Wrox professional guides" ;

<> # Bases de données relationnelles
    a schema:Intangible ;
    schema:name "Bases de données relationnelles"@fr ;

<> # COMPUTERS--Data Processing
    a schema:Intangible ;
    schema:name "COMPUTERS--Data Processing"@en ;

<> # Relational databases
    a schema:Intangible ;
    schema:name "Relational databases"@en ;

<> # Oracle (Computer file)
    a schema:CreativeWork ;
    schema:name "Oracle (Computer file)" ;

    a schema:CreativeWork ;
    rdfs:label "Professional Oracle programming." ;
    schema:description "Print version:" ;
    schema:isSimilarTo <> ; # Professional Oracle programming

    a schema:ProductModel ;
    schema:isbn "0764574825" ;
    schema:isbn "9780764574825" ;

    a schema:ProductModel ;
    schema:isbn "0764598732" ;
    schema:isbn "9780764598739" ;

Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.