×

Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

Beginning Oracle Programming / Edition 1
     

Beginning Oracle Programming / Edition 1

by Sean Dillon, Christopher Beck, Thomas Kyte, Joel Kallman, Howard Rogers
 

ISBN-10: 1590592867

ISBN-13: 9781590592861

Pub. Date: 09/29/2003

Publisher: Apress

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

Overview

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:
9781590592861
Publisher:
Apress
Publication date:
09/29/2003
Edition description:
2002
Pages:
1104
Product dimensions:
7.52(w) x 9.25(h) x 0.07(d)

Table of Contents

Introduction1
Why Read This Book?2
Who Is This Book for?2
What's Covered in This Book?4
What You Need To Use This Book5
Conventions5
Customer Support7
Chapter 1Getting To Know Oracle11
Oracle Fundamental Terms11
Using Oracle14
A Family of Databases19
Summary21
Chapter 2SQL*Plus and Basic Querying23
Introduction To SQL*Plus24
Quick and simple, Querying the Database31
What Is SQL?42
What's in a Table?44
Data Manipulation Language46
Other DML Statements70
COMMIT and ROLLBACK75
Rollback78
Summary79
Chapter 3Creating and Managing Users and Tables81
Data Definition Language81
Tablespaces83
Users84
Oracle Data Types90
Creating Tables106
The Data Dictionary118
Summary123
Chapter 4The New 9i Sample Schemas125
The SCOTT Schema125
The Oracle 9i Sample Schemas126
Summary150
Chapter 5Architecture153
Why Learn the Architecture?154
Making Connections154
Server Processes159
Files161
Memory Areas172
Background Processes176
Overview of the Architecture182
Summary183
Chapter 6Processing Statements in Oracle189
Classes of SQL Statements189
How Statements Are Executed190
A Query from Start To Finish202
DML from Start To Finish203
DDL Processing207
Summary208
Chapter 7Tables211
An Introduction To Tables in Oracle211
Types of Tables212
Table Properties231
Alter Table237
Drop Table246
Truncate Table249
Summary250
Chapter 8Indexes253
Indexes At Work253
Indexes in Oracle254
When Is an Index Useful?258
The Cost of Indexes261
Concatenation275
Indexes and Constraints287
Reverse Key Indexes291
Function-based Indexes294
Bitmap Indexes300
Bitmap Join Indexes304
Summary306
Chapter 9Mastering SQL*Plus309
Advanced Startup Options310
Using SQL*Plus Day-to-Day319
SQL*Plus Commands: A Primer319
Built-In SQL*Plus HELP332
Working with the SQL*Plus Buffer336
Scripts339
Summary342
Chapter 10PL/SQL345
An Overview345
Block-Based Development346
Declarations349
PL/SQL Data Types356
PL/SQL Collections358
Cursors372
Control Statements385
Error Handling394
Summary408
Chapter 11Procedures, Functions, and Packages411
Advantages and Benefits411
Procedures412
Functions436
Packages442
Data Dictionary459
Wrap Utility461
Summary463
Chapter 12Transactions and Concurrency465
What Is a Transaction?465
Transaction Control Statements466
ACID Properties of Transactions475
Concurrency Control484
Summary496
Chapter 13Security499
Overview of Database Security500
Fine-Grained Access Control525
Data Security535
Summary540
Chapter 14Views543
Relational Views544
Inline Views562
Object Views565
Materialized Views568
Summary577
Chapter 15Triggers579
Getting Started580
Types of Triggers583
Enabling and Disabling Triggers607
Transactions and Triggers609
Getting Trigger Information from the Data Dictionary610
Event Attribute Functions611
Summary616
Chapter 16Objects619
Object-Oriented Concepts620
What Is an Object Type?621
Using Object Types622
Object Tables653
Summary659
Chapter 17Advanced Querying661
Herarchical Queries661
User-Defined Aggregate Functions672
Table and Pipelined Functions677
Using Queries To Write SQL with SQL684
Analytic Functions686
Merge698
Summary704
Chapter 18Tuning Tools707
An Approach To Tuning708
Benchmarking709
Bind Variables710
Explain Plan716
Autotrace718
Trace Files and Timed_Statistics725
Summary739
Chapter 19A SQL Toolkit741
Scripts743
Summary784
Case Study 1Debugging PL/SQL787
History787
Requirements788
Database Design and Setup789
Package Layout791
Implementation793
Using Debug817
Troubleshooting Debug817
Debug In-Production Code818
Summary821
Case Study 2Finding People823
History823
The Application826
User Interface846
Summary853
Appendix ASQL Function Reference855
Dual855
Number Functions856
Datetime Functions861
Character Functions870
Conversion Functions878
Aggregation Functions888
Miscellaneous Functions890
Appendix BSupplied Packages901
Appendix CData Dictionary971
DBA_Tables978
DBA_Jobs995
DBA_Types996
DBA_Lobs1001
DBA_Views1003
DBA_Source1008
DBA_Indexes1013
DBA_Roles1017
DBA_Directories1020
Short Names1023
Appendix DInstalling Sample Schemas1025
Installing the SCOTT Schema1025
Installing the Oracle 9/Schemas1026
Installation Wrap Up1038
Appendix EOptions and Features1041
V$ Option1057
Index1059

Customer Reviews

Average Review:

Post to your social network

     

Most Helpful Customer Reviews

See all customer reviews