Expert One-on-One Oracle / Edition 1

Expert One-on-One Oracle / Edition 1

5.0 1
by Thomas Kyte
     
 

Thomas Kyte has a simple philosophy: You can treat Oracle as a black box and shove data inside of it, or you can learn how Oracle works and exploit it as a powerful computing environment. If you choose the latter, you will see there are few information management problems you cannot solve quickly and elegantly.

Kyte has selected the most

See more details below

Overview

Thomas Kyte has a simple philosophy: You can treat Oracle as a black box and shove data inside of it, or you can learn how Oracle works and exploit it as a powerful computing environment. If you choose the latter, you will see there are few information management problems you cannot solve quickly and elegantly.

Kyte has selected the most important features and techniques to discuss in Expert One-on-One Oracle, which he teaches in a proof-by-example manner. He discusses available features, implementing software using these features, and avoiding potential pitfalls.

Product Details

ISBN-13:
9781590592434
Publisher:
Apress
Publication date:
08/14/2003
Edition description:
1st ed. 2nd printing
Pages:
1328
Product dimensions:
7.24(w) x 9.26(h) x 2.25(d)

Table of Contents

Introduction1
Setting Up11
Ch. 1Developing Successful Oracle Applications19
Ch. 2Architecture53
Ch. 3Locking and Concurrency101
Ch. 4Transactions135
Ch. 5Redo and Rollback157
Ch. 6Database Tables197
Ch. 7Indexes269
Ch. 8Import and Export317
Ch. 9Data Loading367
Ch. 10Tuning Strategies and Tools429
Ch. 11Optimizer Plan Stability505
Ch. 12Analytic Functions545
Ch. 13Materialized Views593
Ch. 14Partitioning627
Ch. 15Autonomous Transactions659
Ch. 16Dynamic SQL699
Ch. 17interMedia739
Ch. 18C-Based External Procedures771
Ch. 19Java Stored Procedures843
Ch. 20Using Object Relational Features867
Ch. 21Fine Grained Access Control913
Ch. 22n-Tier Authentication963
Ch. 23Invoker and Definer Rights981
App. ANecessary Supplied Packages1027
DBMS ALERT and DBMS PIPE1031
DBMS APPLICATION INFO1042
DBMS JAVA1050
DBMS JOB1059
DBMS LOB1073
DBMS LOCK1092
DBMS LOGMNR1097
DBMS OBFUSCATION TOOLKIT1123
DBMS OUTPUT1144
DBMS PROFILER1161
DBMS UTILITY1172
UTL FILE1199
UTL HTTP1208
UTL RAW1229
UTL SMTP and Sending Mail1231
UTL TCP1244
Index1265

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >