Oracle Database 10g The Complete Reference

by Loney, Kevin

• ISBN13: 9780072253511
• ISBN10: 0072253517
• Edition: 1st
• Format: Paperback
• Copyright: 2004-09-28
• Publisher: McGraw Hill

Summary

Get a thorough understanding of Oracle Database 10gfrom the most comprehensive Oracle database reference on the market, published by Oracle Press. From critical architecture concepts to advanced object-oriented concepts, this powerhouse contains nearly 50 chapters designed to enlighten you. Upgrade from earlier versions, use SQL, SQL Plus, and PL/SQL. Get code examples and access popular documentation PDFs--plus a full electronic copy of the book on the included CD-ROM. Go beyond the basics and learn security, text searches, external tables, using Java in Oracle, and a great deal more.

Author Biography

Kevin Loney (Wilmington, DE) is a consultant for TUSC and a veteran Oracle developer and DBA. He is among the most renowned members of the Oracle professional community and is a regular presenter at user group conferences.

Table of Contents

I. Critical Architecture Concepts

1. Plan Before You Start - Oracle Architecture Options

2. Installing Oracle Database 10g

3. Upgrading to Oracle Database 10g from Earlier Versions

4. Application Planning / Sharing Knowledge

II. SQL and SQL*Plus

5. The Basic Parts of Speech in SQL

6. Basic SQLPLUS Commands

7. Getting Text Information and Changing It

8. Using Regular Expressions in Oracle Database 10g

9. Querying Numbers

10. Dates - Now, Then and the Difference

11. Conversion and Transformation Functions

12. Grouping Things Together

13. When One Query Depends Upon Another

14. CONNECT BY

15. Changing Data: Insert, Update, Delete, and Merge

16. If, Then, Else: DECODE and CASE

17. Creating, Dropping and Altering Tables, Partitions, and Views

18. Basic Security

III. Beyond the Basics

19. Advanced Security - Virtual Private Databases

20. Creating, Dropping, Renaming, and Transporting Tablespaces

21. SQL*Loader and Export/Import

22. Data Pump

23. Accessing Remote Data

24. Materialized Views and Summary Management

25. Performing Text Searches

26. Using External Tables - Major Updates

27. Flashback - Queries and Transaction History

28. Flashback - DDL and Databases

IV. PL/SQL

29. An introduction to PL/SQL

30. Triggers

31. Procedures, Functions, and Packages

32. Dynamic PL/SQL

V. Object-Relational databases

33. Implementing Types, Object Views, and Methods

34. Collectors (Nested Tables and Varying Arrays)

35. Using Large Objects (LOBs)

36. Advanced Object-Oriented Concepts

VI. Java in Oracle

37. An Introduction to Java

38. JDBC and SQLJ Programming

39. Java Stored Procedures

VII. Clustered Oracle - The Grid

40. Oracle 10g RAC

41. Cluster Workload Management

VIII. Hitchhiker's Guides

42. Hitchhiker's Guide to the Data Dictionary

43. Hitchhiker's Guide to Tuning Oracle

44. Hitchhiker's Guide to HTML DB

45. Hitchhiker's Guide to Oracle Application Server 10g

46. Hitchhiker's Guide to Database Administration

47. Hitchhiker's Guide to XML in Oracle

IX. Alphabetical Reference