Beginning Oracle Programming

By: Sean Dillon, Christopher Beck, Thomas Kyte

Write A Review

Paperback | 29 September 2003

At a Glance

Paperback
1132 Pages

Dimensions(cm)
22.86 x 19.05 x 5.08

Paperback

RRP $89.99

$88.99

or 4 interest-free payments of $22.25 with

Ships in 5 to 7 business days

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.

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $79.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Databases Database Software Oracle Computer Programming & Software Development Programming & Scripting Languages Compilers & Interpreters

Introduction	p. 1
Why Read This Book?	p. 2
Who Is This Book for?	p. 2
What's Covered in This Book?	p. 4
What You Need To Use This Book	p. 5
Conventions	p. 5
Customer Support	p. 7
Getting To Know Oracle	p. 11
Oracle Fundamental Terms	p. 11
Using Oracle	p. 14
A Family of Databases	p. 19
Summary	p. 21
SQL*Plus and Basic Querying	p. 23
Introduction To SQL*Plus	p. 24
Quick and simple, Querying the Database	p. 31
What Is SQL?	p. 42
What's in a Table?	p. 44
Data Manipulation Language	p. 46
Other DML Statements	p. 70
COMMIT and ROLLBACK	p. 75
Rollback	p. 78
Summary	p. 79
Creating and Managing Users and Tables	p. 81
Data Definition Language	p. 81
Tablespaces	p. 83
Users	p. 84
Oracle Data Types	p. 90
Creating Tables	p. 106
The Data Dictionary	p. 118
Summary	p. 123
The New 9i Sample Schemas	p. 125
The SCOTT Schema	p. 125
The Oracle 9i Sample Schemas	p. 126
Summary	p. 150
Architecture	p. 153
Why Learn the Architecture?	p. 154
Making Connections	p. 154
Server Processes	p. 159
Files	p. 161
Memory Areas	p. 172
Background Processes	p. 176
Overview of the Architecture	p. 182
Summary	p. 183
Processing Statements in Oracle	p. 189
Classes of SQL Statements	p. 189
How Statements Are Executed	p. 190
A Query from Start To Finish	p. 202
DML from Start To Finish	p. 203
DDL Processing	p. 207
Summary	p. 208
Tables	p. 211
An Introduction To Tables in Oracle	p. 211
Types of Tables	p. 212
Table Properties	p. 231
Alter Table	p. 237
Drop Table	p. 246
Truncate Table	p. 249
Summary	p. 250
Indexes	p. 253
Indexes At Work	p. 253
Indexes in Oracle	p. 254
When Is an Index Useful?	p. 258
The Cost of Indexes	p. 261
Concatenation	p. 275
Indexes and Constraints	p. 287
Reverse Key Indexes	p. 291
Function-based Indexes	p. 294
Bitmap Indexes	p. 300
Bitmap Join Indexes	p. 304
Summary	p. 306
Mastering SQL*Plus	p. 309
Advanced Startup Options	p. 310
Using SQL*Plus Day-to-Day	p. 319
SQL*Plus Commands: A Primer	p. 319
Built-In SQL*Plus HELP	p. 332
Working with the SQL*Plus Buffer	p. 336
Scripts	p. 339
Summary	p. 342
PL/SQL	p. 345
An Overview	p. 345
Block-Based Development	p. 346
Declarations	p. 349
PL/SQL Data Types	p. 356
PL/SQL Collections	p. 358
Cursors	p. 372
Control Statements	p. 385
Error Handling	p. 394
Summary	p. 408
Procedures, Functions, and Packages	p. 411
Advantages and Benefits	p. 411
Procedures	p. 412
Functions	p. 436
Packages	p. 442
Data Dictionary	p. 459
Wrap Utility	p. 461
Summary	p. 463
Transactions and Concurrency	p. 465
What Is a Transaction?	p. 465
Transaction Control Statements	p. 466
ACID Properties of Transactions	p. 475
Concurrency Control	p. 484
Summary	p. 496
Security	p. 499
Overview of Database Security	p. 500
Fine-Grained Access Control	p. 525
Data Security	p. 535
Summary	p. 540
Views	p. 543
Relational Views	p. 544
Inline Views	p. 562
Object Views	p. 565
Materialized Views	p. 568
Summary	p. 577
Triggers	p. 579
Getting Started	p. 580
Types of Triggers	p. 583
Enabling and Disabling Triggers	p. 607
Transactions and Triggers	p. 609
Getting Trigger Information from the Data Dictionary	p. 610
Event Attribute Functions	p. 611
Summary	p. 616
Objects	p. 619
Object-Oriented Concepts	p. 620
What Is an Object Type?	p. 621
Using Object Types	p. 622
Object Tables	p. 653
Summary	p. 659
Advanced Querying	p. 661
Herarchical Queries	p. 661
User-Defined Aggregate Functions	p. 672
Table and Pipelined Functions	p. 677
Using Queries To Write SQL with SQL	p. 684
Analytic Functions	p. 686
Merge	p. 698
Summary	p. 704
Tuning Tools	p. 707
An Approach To Tuning	p. 708
Benchmarking	p. 709
Bind Variables	p. 710
Explain Plan	p. 716
Autotrace	p. 718
Trace Files and Timed_Statistics	p. 725
Summary	p. 739
A SQL Toolkit	p. 741
Scripts	p. 743
Summary	p. 784
Debugging PL/SQL	p. 787
History	p. 787
Requirements	p. 788
Database Design and Setup	p. 789
Package Layout	p. 791
Implementation	p. 793
Using Debug	p. 817
Troubleshooting Debug	p. 817
Debug In-Production Code	p. 818
Summary	p. 821
Finding People	p. 823
History	p. 823
The Application	p. 826
User Interface	p. 846
Summary	p. 853
SQL Function Reference	p. 855
Dual	p. 855
Number Functions	p. 856
Datetime Functions	p. 861
Character Functions	p. 870
Conversion Functions	p. 878
Aggregation Functions	p. 888
Miscellaneous Functions	p. 890
Supplied Packages	p. 901
Data Dictionary	p. 971
DBA_Tables	p. 978
DBA_Jobs	p. 995
DBA_Types	p. 996
DBA_Lobs	p. 1001
DBA_Views	p. 1003
DBA_Source	p. 1008
DBA_Indexes	p. 1013
DBA_Roles	p. 1017
DBA_Directories	p. 1020
Short Names	p. 1023
Installing Sample Schemas	p. 1025
Installing the SCOTT Schema	p. 1025
Installing the Oracle 9/Schemas	p. 1026
Installation Wrap Up	p. 1038
Options and Features	p. 1041
V$ Option	p. 1057
Index	p. 1059
Table of Contents provided by Ingram. All Rights Reserved.

Beginning Oracle Programming

At a Glance

Paperback

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Computer Programming & Software Development

Beginner's Step-by-Step Coding Course

Learn Computer Programming the Easy Way

Python Crash Course

3rd Edition - A Hands-On, Project-Based Introduction to Programming

The C Programming Language

Prentice Hall Software

Addiction by Design

Machine Gambling in Las Vegas

Python Automation For Dummies

For Dummies (Computer/Tech)

Machine Learning For Dummies

For Dummies (Computer/Tech)

The Legend of Zelda(tm) Tears of the Kingdom - The Complete Official Guide

Collector's Edition

Arduino For Dummies

For Dummies (Computer/Tech)

Make: Electronics, 3e

Learning by Discovery: A hands-on primer for the new electronics enthusiast

Python All-in-One For Dummies

3rd Edition

Fun Python GUI Projects in easy steps

In Easy Steps

The Garbage Collection Handbook

The Art of Automatic Memory Management

Teach Yourself VISUALLY iPhone 17 and iPhone Air

Teach Yourself VISUALLY (Tech)

Python Workout, Second Edition

200 ten-minute exercises

The Linux Command Line, 3rd Edition

A Complete Introduction

Make : Analog Synthesizers

A modern approach to old-school sound synthesis

The Man Who Solved the Market

How Jim Simons Launched the Quant Revolution SHORTLISTED FOR THE FT & MCKINSEY BUSINESS BOOK OF THE YEAR AWARD 2019

Building Microservices

Designing Fine-Grained Systems 2nd Edition

The Pragmatic Programmer 2nd edition

your journey to mastery, 20th Anniversary Edition

Code

2nd Edition - The Hidden Language of Computer Hardware and Software

Coding For Kids For Dummies

For Kids for Dummies

Effective Modern C++

42 Specific Ways to Improve Your Use of C++11 And C++14

The Practical Guide

Web Engineering

Theory and Practice

This product is categorised by