| help | account  


Oracle Database 10g: The Complete Reference
View Larger Image
Kevin Loney
Oracle Press, Paperback, Bk&CD edition, Published September 2004, 1369 pages, ISBN 0072253517
List Price: $73.99
Our Price: $44.95
You Save: $29.04 (39% Off)


FREE Shipping on Orders over $40!*
Availability: In-Stock

Be the First to Write a Review and tell the world about this title!

People who purchase this book frequently purchase:

Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:

Get a thorough understanding of Oracle Database 10g from 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.

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. Hitchhikers Guides

42. Hitchhikers Guide to the Data Dictionary

43. Hitchhikers Guide to Tuning Oracle

44. Hitchhikers Guide to HTML DB

45. Hitchhikers Guide to Oracle Application Server 10g

46. Hitchhikers Guide to Database Administration

47. Hitchhikers Guide to XML in Oracle

IX. Alphabetical Reference

About the Author

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.




Forgot your password?
FAQs
Shipping Options
Returns
Your Orders
Your Account