Beginning Oracle Programming / Edition 1
by Sean Dillon, Howard Rogers, Joel Kallman, Thomas Kyte
This book teaches you all of the core concepts behind using the database, provides you the tools and techniques you need to master, and gives you practical working examples of Oracle programming in action. This book is aimed at would-be Oracle developers and administrators alike. No matter what your background, this book can guide you, using a straightforward and
… See more details belowOverview
This book teaches you all of the core concepts behind using the database, provides you the tools and techniques you need to master, and gives you practical working examples of Oracle programming in action. This book is aimed at would-be Oracle developers and administrators alike. No matter what your background, this book can guide you, using a straightforward and practical approach to the technology. By the time youve completed it, youll have all the knowledge you need to use Oracle databases with confidence.
As the world's leading relational database, Oracle provides a rich environment to store, handle, and extract data. When used properly, it is the fastest and most scalable database for building enterprise applications. However, with power comes complexity, and mastering the Oracle database is not an overnight job. It takes time, practice, and real world experience. The authors of this book provide you with the tools to gain that experience. They understand the challenges that need to be met when developing applications, and they guarantee that the techniques taught in this book will lead you through many successful implementations.
Product Details
- ISBN-13:
- 9781861006905
- Publisher:
- Wrox Press, Inc.
- Publication date:
- 03/01/2002
- Series:
- Beginning Ser.
- Pages:
- 1000
- Product dimensions:
- 7.24(w) x 8.94(h) x 1.96(d)
Table of Contents
Introduction | 1 | |
Ch. 1 | Getting To Know Oracle | 11 |
Ch. 2 | SQL Plus and Basic Querying | 23 |
Ch. 3 | Creating and Managing Users and Tables | 81 |
Ch. 4 | The New 9/ Sample Schemas | 125 |
Ch. 5 | Architecture | 153 |
Ch. 6 | Processing Statements in Oracle | 189 |
Ch. 7 | Tables | 211 |
Ch. 8 | Indexes | 253 |
Ch. 9 | Mastering SQL*Plus | 309 |
Ch. 10 | Pl/Sql | 345 |
Ch. 11 | Procedures, Functions, and Packages | 411 |
Ch. 12 | Transactions and Concurrency | 465 |
Ch. 13 | Security | 499 |
Ch. 14 | Views | 543 |
Ch. 15 | Triggers | 579 |
Ch. 16 | Objects | 619 |
Ch. 17 | Advanced Querying | 661 |
Ch. 18 | Tuning Tools | 707 |
Ch. 19 | A SQL Toolkit | 741 |
Case Study 1 | Debugging PL/SQL | 787 |
Case Study 2 | Finding People | 823 |
App. A | SQL Function Reference | 855 |
App. B | Supplied Packages | 901 |
App. C | Data Dictionary | 971 |
App. D | Installing Sample Schemas | 1025 |
App. E | Options and Features | 1041 |
Index | 1069 |
Customer Reviews
Average Review: