Beginning Oracle programming
Sean Dillon, Christopher Beck, Thomas Kyte, Howard Rogers, Joel Kallman
Résumé
This book teaches you all of the core concepts behind using the database, shows you the tools and techniques you need to master, and gives you practical examples of programming Oracle. This book is aimed at would-be Oracle developers and administrators alike. No matter what your background might be, this book takes a simple approach to teaching you Oracle technology. By the time you have completed this book, you will have all the knowledge you need to use Oracle databases with confidence.
Oracle is the world's leading relational database. It provides a rich environment to store, handle, and extract data and, when used properly, is the fastest and most scaleable database on which to build enterprise scale applications. However, with power comes complexity and mastering the Oracle database is not an overnight job. It takes time, practice, and a lot of real world experience. The authors of this book have that experience. They understand the challenges that are going to be met when developing an application or administering the database and can guarantee you that the techniques taught in this book are proven and have led them through many successful implementations.
Contents
- Introduction
- Getting to Know Oracle
- SQL PLUS and Basic Querying
- Creating and Managing Users and Tables
- The 9i Sample Schemas
- Architecture
- Processing Statements in Oracle
- Tables
- Indexes
- Mastering SQL*PLUS
- PL/SQL
- Procedures, Functions and Packages
- Transactions and Concurrency
- Security
- Views
- Triggers
- Objects
- Advanced Querying
- Tuning Tools
- A SQL Toolkit
- Case Study 1--Debugging PL/SQL
- Case Study 2--Finding People
- Appendix A--SQL Function Reference
- Appendix B--Supplied Packages
- Appendix C--Data Dictionary
- Appendix D--Installing Sample Schemas
- Appendix E--Options and Features
- Index
L'auteur - Sean Dillon
Sean Dillon - Sean Dillon started programming a Commodore Vic 20 back in 1980 at the age of nine. Sean grew and so did his love for programming. He began his professional programming career in the United States Marine Corps, shortly after returning from the Gulf War. Sean is now a Principal Technologist, working for Oracle Corporation based in Reston, Virginia. He has ten years of experience specializing in database architecture, database tuning, web application development, XML, and Web Services technologies.
L'auteur - Christopher Beck
Christoper Beck - Christopher Beck has a bachelor's degree in Computer Science from Rutgers University. He has worked in the industry for 11 years. Starting off as a junior Ada software developer for a government systems integrator, he has spent the last seven years with Oracle Corporation and is now a Principal Technologist there. He specializes in core database technologies and web application development. WebView, a "science project" that he and a colleague wrote, has now become the commercial product known as Oracle Portal.
L'auteur - Thomas Kyte
Thomas Kyte - Thomas Kyte is the Vice President of the Core Technologies Group at Oracle Corporation and has been with them since version 7.0.9 was released in 1993. Kyte, however, has been working with Oracle since version 5.1.5c. At Oracle Corp., Kyte works with the Oracle database, and more specifically, he helps clients who are using the Oracle database and works directly with them specifying and building their systems or rebuilding and tuning them. Prior to working at Oracle, Kyte was a systems integrator who built large scale, heterogeneous databases and applications for military and government clients. Tom Kyte is the same 'Ask Tom' whose column appears in Oracle Magazine, where he answers questions about the Oracle database and tools that developers and DBAs struggle with every day.
L'auteur - Joel Kallman
Joel Kallman - Joel Kallman is a Web systems technologist for Oracle Corporation. His background over the past 13 years has centered around database and content management, from SGML databases and publishing systems to text and document management. He is currently developing solutions and tools for customers to easily build database-centric Web applications. Joel is a proud alumnus of The Ohio State University, where he received his bachelor's degree in Computer Engineering. He and his wife Kristin reside in Powell, Ohio.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Apress |
| Auteur(s) | Sean Dillon, Christopher Beck, Thomas Kyte, Howard Rogers, Joel Kallman |
| Parution | 30/10/2003 |
| Nb. de pages | 1116 |
| Format | 18,5 x 23 |
| Couverture | Broché |
| Poids | 1550g |
| Intérieur | Noir et Blanc |
| EAN13 | 9781590592861 |
| ISBN13 | 978-1-59059-286-1 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
