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

or

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.

More in Computer Programming & Software Development

Beginner's Step-by-Step Coding Course

Learn Computer Programming the Easy Way

Hardcover

RRP $45.00

$35.75

21%
OFF

Python Crash Course

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

Paperback

RRP $89.99

$64.99

28%
OFF

Coding For Kids For Dummies

For Kids for Dummies

Paperback

RRP $36.95

$29.75

19%
OFF

The C Programming Language

Prentice Hall Software

Paperback

RRP $107.04

$73.75

31%
OFF

Python All-in-One For Dummies

3rd Edition

Paperback

RRP $74.95

$55.75

26%
OFF

Python Workout, Second Edition : 200 ten-minute exercises - Reuven Lerner

$55.75

51%
OFF

Fundamentals of Software Architecture

A Modern Engineering Approach

Paperback

RRP $152.00

$73.75

51%
OFF

Web Engineering : Theory and Practice - Jeremiah Downey

$Typesetting Mathematics With Latex - Robert Legato$

$73.75

51%
OFF

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

Paperback

RRP $26.99

$22.99

15%
OFF

The Pragmatic Programmer 2nd edition

your journey to mastery, 20th Anniversary Edition

Hardcover

RRP $91.30

$62.75

31%
OFF

Coding For Dummies, All New Edition : For Dummies (Computer/Tech) - Paul McFedries

$33.75

20%
OFF

The Art of Game Design

A Book of Lenses, Third Edition

Paperback

RRP $120.00

$90.75

24%
OFF

Artificial Intelligence Programming with Python

From Zero to Hero

Paperback

RRP $65.95

$49.75

25%
OFF

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

Coding For Kids For Dummies

For Kids for Dummies

The C Programming Language

Prentice Hall Software

Python All-in-One For Dummies

3rd Edition

Python Workout, Second Edition

200 ten-minute exercises

Effective Modern C++

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

Fundamentals of Software Architecture

A Modern Engineering Approach

Web Engineering

Theory and Practice

The Essence of Software Engineering

Parallel Computing

Design and Analysis of Algorithms

Introduction to Programming Languages

Typesetting Mathematics With Latex

Semantics With Applications

Advanced Topics in Computer Science

Practical Probabilistic Programming

Practical Probabilistic Programming

Heuristic Algorithms Design

A Methodological Approach

Head First Design Patterns

Building Extensible and Maintainable Object-Oriented Software 2nd Edition

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

The Pragmatic Programmer 2nd edition

your journey to mastery, 20th Anniversary Edition

Coding For Dummies, All New Edition

For Dummies (Computer/Tech)

Windows 11 For Seniors For Dummies, 2nd Edition

For Dummies (Computer/Tech)

The Art of Game Design

A Book of Lenses, Third Edition

Artificial Intelligence Programming with Python

From Zero to Hero

This product is categorised by