Skip to main content
  • Book
  • © 2002

Beginning Oracle Programming

Apress
  • A detailed tutorial that takes you from no knowledge of Oracle programming to mastery, teaching you how to write correct, production quality code right from the start

  • A clear, step-by-step guide to every aspect of programming the Oracle database, with practical programming techniques and troubleshooting advice from Oracle experts

  • Provides an extensive SQL toolkit to tackle common day-to-day database tasks

Buy it now

Buying options

eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (22 chapters)

  1. Front Matter

    Pages N2-xviii
  2. Introduction

    • Sean Dillon, Christopher Beck, Thomas Kyte, Joel Kallman, Howard Rogers
    Pages 1-8
  3. Getting To Know Oracle

    • Sean Dillon, Christopher Beck, Thomas Kyte, Joel Kallman, Howard Rogers
    Pages 11-21
  4. SQL*Plus and Basic Querying

    • Sean Dillon, Christopher Beck, Thomas Kyte, Joel Kallman, Howard Rogers
    Pages 23-79
  5. Creating and Managing Users and Tables

    • Sean Dillon, Christopher Beck, Thomas Kyte, Joel Kallman, Howard Rogers
    Pages 81-123
  6. The New 9i Sample Schemas

    • Sean Dillon, Christopher Beck, Thomas Kyte, Joel Kallman, Howard Rogers
    Pages 125-150
  7. Architecture

    • Sean Dillon, Christopher Beck, Thomas Kyte, Joel Kallman, Howard Rogers
    Pages 153-184
  8. Processing Statements in Oracle

    • Sean Dillon, Christopher Beck, Thomas Kyte, Joel Kallman, Howard Rogers
    Pages 189-208
  9. Tables

    • Sean Dillon, Christopher Beck, Thomas Kyte, Joel Kallman, Howard Rogers
    Pages 211-250
  10. Indexes

    • Sean Dillon, Christopher Beck, Thomas Kyte, Joel Kallman, Howard Rogers
    Pages 253-306
  11. Mastering SQL*Plus

    • Sean Dillon, Christopher Beck, Thomas Kyte, Joel Kallman, Howard Rogers
    Pages 309-342
  12. PL/SQL

    • Sean Dillon, Christopher Beck, Thomas Kyte, Joel Kallman, Howard Rogers
    Pages 345-408
  13. Procedures, Functions, and Packages

    • Sean Dillon, Christopher Beck, Thomas Kyte, Joel Kallman, Howard Rogers
    Pages 411-463
  14. Transactions and Concurrency

    • Sean Dillon, Christopher Beck, Thomas Kyte, Joel Kallman, Howard Rogers
    Pages 465-496
  15. Security

    • Sean Dillon, Christopher Beck, Thomas Kyte, Joel Kallman, Howard Rogers
    Pages 499-540
  16. Views

    • Sean Dillon, Christopher Beck, Thomas Kyte, Joel Kallman, Howard Rogers
    Pages 543-577
  17. Triggers

    • Sean Dillon, Christopher Beck, Thomas Kyte, Joel Kallman, Howard Rogers
    Pages 579-616
  18. Objects

    • Sean Dillon, Christopher Beck, Thomas Kyte, Joel Kallman, Howard Rogers
    Pages 619-659
  19. Advanced Querying

    • Sean Dillon, Christopher Beck, Thomas Kyte, Joel Kallman, Howard Rogers
    Pages 661-704
  20. Tuning Tools

    • Sean Dillon, Christopher Beck, Thomas Kyte, Joel Kallman, Howard Rogers
    Pages 707-739

About this book

Why Read This Book? When you opened the cover of this book, you had a notion of what you would find. With a title like Beginning Oracle Programming, it's fairly obvious what this book is all about. Simply put, the purpose of this book is to teach you how to manage data using an Oracle database. The goal of Beginning Oracle Programming is to introduce you to those concepts that are important to understand as a beginning-level Oracle user. You are setting out on the same journey we traveled some years ago. We know the things you are going to run into time and time again. We understand the challenges you are going to meet when you have to develop an application or administer your database. We can guarantee you that the techniques you'll learn in this book are proven and have led us through many successful implementations. So instead of talking about the things we want to teach you in an abstract kind of way, let's talk specifics.

About the authors

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.

Christopher 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.

Thomas Kyte: Thomas Kyte is the Vice President of the Core Technologies Group at Oracle Corporation. He has been working for Oracle since version 7.0.9 (that's 1993 for people who don't mark time by Oracle versions). However, he has been working with Oracle since about version 5.1.5c. Before coming to work at Oracle, Thomas worked for more than six years as a systems integrator building large scale, heterogeneous databases and applications, mostly for military and government customers. These days, he spends a great deal of time working with the Oracle database and, more specifically, helping people who are using the Oracle database. He works directly with customers, either in specifying and building their systems or, more frequently, helping them rebuild or tune them ('tuning' frequently being a synonym for rebuilding). In addition, he is the Tom behind 'AskTom' in Oracle Magazine, answering people's questions about the Oracle database and tools. On a typical day, he receives and answers 30 to 40 questions at http://asktom.oracle.com. Every two months, he publishes a 'best of' in the magazine (all of the questions asked are available on the Web – stored in an Oracle database of course). He is the author of "Expert One-on-One Oracle" and "Effective Oracle by Design" and the contributing author of "Professional Oracle 8i Application Programming".

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. When he's not consumed by the daily advances in computer technology, he enjoys reading about investment principles as well as working out at the local "Y". 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.

Bibliographic Information

  • Book Title: Beginning Oracle Programming

  • Authors: Sean Dillon, Christopher Beck, Thomas Kyte, Joel Kallman, Howard Rogers

  • DOI: https://doi.org/10.1007/978-1-4302-5370-9

  • Publisher: Apress Berkeley, CA

  • eBook Packages: Springer Book Archive

  • Copyright Information: Sean Dillon and Christopher Beck and Thomas Kyte and Joel Kallman and Howard Rogers 2002

  • Softcover ISBN: 978-1-59059-286-1Published: 29 September 2003

  • eBook ISBN: 978-1-4302-5370-9Published: 11 November 2013

  • Edition Number: 1

  • Number of Pages: XVIII, 1104

  • Topics: Database Management, Programming Languages, Compilers, Interpreters

Buy it now

Buying options

eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access