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

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
Summary:
"If you are a developer who wants to use Oracle to build effective, robust, and scalable software applications, look no further. Written by a team of leading authorities on the Oracle database, this example-packed book is divided into three main areas: how the Oracle database works, how to use SQL and programming languages to access Oracle, and how to use the features of Oracle effectively in creating your  Read more...
Rating:

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

Subjects
More like this

 

Find a copy in the library

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

Details

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 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.
Series Title: Wrox professional guides.
Responsibility: Rick Greenwald [and others].

Abstract:

"If you are a developer who wants to use Oracle to build effective, robust, and scalable software applications, look no further. Written by a team of leading authorities on the Oracle database, this example-packed book is divided into three main areas: how the Oracle database works, how to use SQL and programming languages to access Oracle, and how to use the features of Oracle effectively in creating your applications."--Jacket.

Reviews

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 2005)

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

Tags

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

<http://www.worldcat.org/oclc/70720194> # Professional Oracle programming
    a schema:CreativeWork, schema:MediaObject, schema:Book ;
    library:oclcnum "70720194" ;
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/inu> ;
    library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/1044585284#Place/indianapolis_ind> ; # Indianapolis, Ind.
    rdfs:comment "Warning: This malformed URI has been treated as a string - 'http://www.contentreserve.com/TitleInfo.asp?ID={E70BC296-361F-4C46-AE19-AE2CEE6ABDB6}&Format=50'" ;
    rdfs:comment "Warning: This malformed URI has been treated as a string - 'http://public.eblib.com/choice/publicfullrecord.aspx?p=231711userid=^u'" ;
    schema:about <http://experiment.worldcat.org/entity/work/data/1044585284#CreativeWork/oracle_computer_file> ; # Oracle (Computer file)
    schema:about <http://id.worldcat.org/fast/1093575> ; # Relational databases
    schema:about <http://experiment.worldcat.org/entity/work/data/1044585284#Topic/computers_data_processing> ; # COMPUTERS--Data Processing
    schema:about <http://dewey.info/class/005.7585/e22/> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/1044585284#Topic/bases_de_donnees_relationnelles> ; # Bases de données relationnelles
    schema:about <http://id.worldcat.org/fast/1363816> ; # Oracle (Computer file)
    schema:about <http://experiment.worldcat.org/entity/work/data/1044585284#CreativeWork/oracle_logiciel> ; # Oracle (Logiciel)
    schema:bookFormat schema:EBook ;
    schema:contributor <http://viaf.org/viaf/85502526> ; # Rick Greenwald
    schema:copyrightYear "2005" ;
    schema:datePublished "2005" ;
    schema:description ""If you are a developer who wants to use Oracle to build effective, robust, and scalable software applications, look no further. Written by a team of leading authorities on the Oracle database, this example-packed book is divided into three main areas: how the Oracle database works, how to use SQL and programming languages to access Oracle, and how to use the features of Oracle effectively in creating your applications."--Jacket."@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/1044585284> ;
    schema:genre "Electronic books"@en ;
    schema:inLanguage "en" ;
    schema:isPartOf <http://experiment.worldcat.org/entity/work/data/1044585284#Series/wrox_professional_guides> ; # Wrox professional guides.
    schema:isSimilarTo <http://worldcat.org/entity/work/data/1044585284#CreativeWork/professional_oracle_programming> ;
    schema:name "Professional Oracle programming"@en ;
    schema:productID "70720194" ;
    schema:publication <http://www.worldcat.org/title/-/oclc/70720194#PublicationEvent/indianapolis_ind_wiley_pub_2005> ;
    schema:publisher <http://experiment.worldcat.org/entity/work/data/1044585284#Agent/wiley_pub> ; # Wiley Pub.
    schema:url <http://ebookcentral.proquest.com/lib/columbia/detail.action?docID=231711> ;
    schema:url <http://er.llcc.edu:2048/login?url=http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=133976> ;
    schema:url <http://www.myilibrary.com?id=27916&ref=toc> ;
    schema:url <http://www.123library.org/book_details/?id=11558> ;
    schema:url <http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=133976> ;
    schema:url <http://site.ebrary.com/id/10114235> ;
    schema:url "http://www.contentreserve.com/TitleInfo.asp?ID={E70BC296-361F-4C46-AE19-AE2CEE6ABDB6}&Format=50" ;
    schema:url <http://public.eblib.com/choice/publicfullrecord.aspx?p=231711> ;
    schema:url <http://www.myilibrary.com?id=27916> ;
    schema:url "http://public.eblib.com/choice/publicfullrecord.aspx?p=231711userid=^u" ;
    schema:url <http://public.ebookcentral.proquest.com/choice/publicfullrecord.aspx?p=231711> ;
    schema:workExample <http://worldcat.org/isbn/9780764598739> ;
    schema:workExample <http://worldcat.org/isbn/9780764574825> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/70720194> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/1044585284#CreativeWork/oracle_computer_file> # Oracle (Computer file)
    a schema:CreativeWork ;
    schema:name "Oracle (Computer file)" ;
    .

<http://experiment.worldcat.org/entity/work/data/1044585284#Place/indianapolis_ind> # Indianapolis, Ind.
    a schema:Place ;
    schema:name "Indianapolis, Ind." ;
    .

<http://experiment.worldcat.org/entity/work/data/1044585284#Series/wrox_professional_guides> # Wrox professional guides.
    a bgn:PublicationSeries ;
    schema:hasPart <http://www.worldcat.org/oclc/70720194> ; # Professional Oracle programming
    schema:name "Wrox professional guides." ;
    schema:name "Wrox professional guides" ;
    .

<http://experiment.worldcat.org/entity/work/data/1044585284#Topic/bases_de_donnees_relationnelles> # Bases de données relationnelles
    a schema:Intangible ;
    schema:name "Bases de données relationnelles"@fr ;
    .

<http://experiment.worldcat.org/entity/work/data/1044585284#Topic/computers_data_processing> # COMPUTERS--Data Processing
    a schema:Intangible ;
    schema:name "COMPUTERS--Data Processing"@en ;
    .

<http://id.worldcat.org/fast/1093575> # Relational databases
    a schema:Intangible ;
    schema:name "Relational databases"@en ;
    .

<http://id.worldcat.org/fast/1363816> # Oracle (Computer file)
    a schema:CreativeWork ;
    schema:name "Oracle (Computer file)" ;
    .

<http://viaf.org/viaf/85502526> # Rick Greenwald
    a schema:Person ;
    schema:familyName "Greenwald" ;
    schema:givenName "Rick" ;
    schema:name "Rick Greenwald" ;
    .

<http://worldcat.org/entity/work/data/1044585284#CreativeWork/professional_oracle_programming>
    a schema:CreativeWork ;
    rdfs:label "Professional Oracle programming." ;
    schema:description "Print version:" ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/70720194> ; # Professional Oracle programming
    .

<http://worldcat.org/isbn/9780764574825>
    a schema:ProductModel ;
    schema:isbn "0764574825" ;
    schema:isbn "9780764574825" ;
    .

<http://worldcat.org/isbn/9780764598739>
    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.