Professional Oracle Programming

Professional Oracle Programming

4.16 (6 ratings by Goodreads)
By (author)  , By (author)  , By (author)  , By (author)  , By (author)  , By (author) 

List price: US$39.99

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks


One of the only Oracle books to focus exclusively on database programming rather than administration Oracle owns sixty percent of the commercial database market Provides 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 9i The authors are well-known as Oracle gurus-Greenwald is the author of Oracle in a Nutshell and the coauthor, with Stackowiak, of Oracle 9 Essentials Shows how to use Oracle data and data structures to build robust, scalable database applications using Java, SQL, and PL/SQL
show more

Product details

  • Online resource | 790 pages
  • 190 x 232 x 44mm | 1,138.53g
  • John Wiley & Sons Inc
  • Hungry Minds Inc,U.S.
  • Foster City, United States
  • English
  • 0764574825
  • 9780764574825

Back cover copy

Professional Oracle ProgrammingIf 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.After an overview of the topics you need to know in order to use the Oracle database effectively, you'll get helpful tips, techniques, code samples, and examples written in Oracle Database 10g. Along the way, you'll learn how to access and manipulate data in the Oracle database, implement logic with various programming techniques, use raw data in a database, and, ultimately, create successful applications.What you will learn from this bookHow to leverage Oracle's strengths in both its functionality and operationsVarious database issues that have a direct impact on the operation and performance of Oracle applicationsTechniques for using triggers, regular expressions, object types, XML, and HTML-DB with OracleHow Oracle processes SQL requests and the implication this can have on application codeWays Oracle determines optimal access paths to data and how to shape the behavior of an Oracle databaseWho this book is forThis book is for anyone whose primary job is to create application systems and who wants to use the Oracle database for such systems. A basic knowledge of Oracle, Java, and SQL is recommended.Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.
show more

Review quote

"...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)
show more

About Richard Greenwald

Rick Greenwald has been in the technology industry for over 20 years and is the author of 12 previous books, most of them on Oracle. He has been involved with development and databases for his entire career, including stops at Data General, Cognos, Gupta Technologies, and his current employer, Oracle. Computers and computing are a sideline for Rick - his real job is father to his three wonderful girls, with a primary hobby of music appreciation. Robert Stackowiak is Senior Director of Business Intelligence (BI) in Oracle's Technology Business Unit. He is recognized worldwide for his expertise in business intelligence and data warehousing in leading the North American BI team at Oracle. His background includes over 20 years in IT related roles at Oracle, IBM, Harris Computer Systems, and the U.S. Army Corps of Engineers including management of technical teams, software development, sales and sales consulting, systems engineering, and business development. Gary Dodge has been focused on database technology since his first COBOL programming job with IMS DB/DC in 1976. He joined Oracle Corporation in 1987 and has served in various management and technical positions within both the sales and consulting divisions. He has been a frequent speaker on database topics at many local and national information technology conferences. In addition to several magazine articles, he is co-author (with Tim Gorman) of Oracle8 Data Warehousing and Essential Oracle8i Data Warehousing, both published by John Wiley & Sons. David Klein has been in the technology industry for over 20 years with a variety of companies, including Data General, Wang Laboratories, Gupta Technologies, Oracle, and a few consulting services companies. He has had many roles, including management of application development and database design teams, sales and sales consulting, systems engineering and marketing. Recently, he has focused on developing classroom and online training courses. An active wife and two boys and a 200-year-old house take up any free time. Ben Shapiro is the president of ObjectArts Inc., a New York City-based technology consulting company, and has been designing database systems with Oracle since 1997. ObjectArts has worked with many large corporate clients developing XML-based publishing tools and web-based applications. Before ObjectArts, Ben worked with several NYC-based startup companies as a technical lead building content management software. Christopher G. Chelliah joined Oracle as a Consultant in 1995. He brings with him project management, architecture, and development experience from a number of large, multinational sites in the mining, oil and gas, and telecom industries. Chris has been involved with emerging and database technologies for his entire career and is an accomplished software architect with a flair for business development. His expertise has been actively sought by a number of major Oracle clients in Australia, Europe, and the United States. Chris, his wife and two kids are currently in Singapore, where he leads a team defining and executing on innovative E-Government strategies for Oracle's Public Sector industry in Asia Pacific.
show more

Table of contents

About the Authors. Acknowledgments. Introduction. Introduction. What Does This Book Cover? Who Is This Book For? What You Need to Use This Book. How Is This Book Structured? Part I: Oracle Essentials. Part II: Data Topics. Part III: Database Programming Languages. Part IV: Programming Techniques. Part V: Business Intelligence Techniques. Part VI: Optimization. The Bigger Picture. Conventions. Source Code. Errata. Chapter 1: Oracle Architecture and Storage. Chapter 2: Using SQL. Chapter 3: Handling Multiple Users. Chapter 4: Database Design Basics. Chapter 5: Oracle Security. Chapter 6: The Oracle Data Dictionary. Chapter 7: Installing Oracle. Chapter 8: Introduction to SQL. Chapter 9: Extended SQL. Chapter 10: Indexes. Chapter 11: Constraints. Chapter 12: Other Database Structures. Chapter 13: Functions. Chapter 14: Distributed Queries, Transactions, and Databases. Chapter 15: PL/SQL Basics. Chapter 16: PL/SQL and SQL. Chapter 17: PL/SQL Packages. Chapter 18: Introduction to Java Database Programming. Chapter 19: Triggers. Chapter 20: Regular Expressions and Expression Filter. Chapter 21: Object Relational Interactions with Oracle. Chapter 22: Oracle XML DB. Chapter 23: HTML-DB. Chapter 24: High-Speed Data Movement. Chapter 25: Data Loading and Management. Chapter 26: Business Intelligence Query. Chapter 27: Business Intelligence Analysis. Chapter 28: Optimization. Index.
show more

Rating details

6 ratings
4.16 out of 5 stars
5 50% (3)
4 17% (1)
3 33% (2)
2 0% (0)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X