Cover Image
Read Now

Oracle Database 10g the complete reference

Bibliographic Details
Main Author: Loney, Kevin
Format: eBook
Language:English
Published: Emeryville, Calif. McGraw-Hill/Osborne 2004
Subjects:
Oracle (computer File) / Http://id.loc.gov/authorities/names/n91015760
Oracle (computer File) / Blmlsh
Oracle (computer File) / Fast
Computer Science
Engineering & Applied Sciences
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
Table of Contents:
  • 20. Working with tablespaces
  • 21. Using SQL* Loader to load data
  • 22. Using data pump export and import
  • 23. Accessing remote data
  • 24. Using materialized views
  • 25. Using Oracle Text for text searches
  • 26. Using external tables
  • 27. Using flashback queries
  • 28. Flashback
  • table and databases
  • pt. IV. Pl/Sql
  • 29. An introduction to PL/SQL
  • 30. Triggers
  • 31. Procedures, functions, and packages
  • 32. Using native dynamic SQL and DBMSS̲QL
  • pt. V. Object-relational databases
  • 33. Implementing types, object views, and methods
  • 34. Collectors (nested tables and varying arrays)
  • 35. Using large objects
  • 36. Advanced object-oriented concepts
  • pt. VI. Java in Oracle
  • 37. An introduction to Java
  • 38. JDBC programming
  • 39. Java stored procedures
  • pt. VII. Clustered Oracle
  • the grid
  • 40. Oracle real application clusters
  • 41. Grid architecture and management
  • pt. VIII. Hitchhiker's guides
  • pt. I. Critical database concepts
  • 1. Oracle Database 10g architecture options
  • 2. Installing Oracle Database 10g and creating a database
  • 3. Upgrading to Oracle Database 10g
  • 4. Planning Oracle applications
  • approaches, risks, and standards
  • pt. II. SQL and SQL* Plus
  • 5. The basic parts of speech in SQL
  • 6. Basic SQL Plus* reports and commands
  • 7. Getting text information and changing it
  • 8. Searching for regular expressions
  • 9. Playing the numbers
  • 10. Dates : then, now, and the difference
  • 11. Conversion and transformation functions
  • 12. Grouping things together
  • 13. When one query depends upon another
  • 14. Some complex possibilities
  • 15. Changing data : insert, update, merge, and delete
  • 16. DECODE and CASE : if, then, and else in SQL
  • 17. Creating and managing tables, views, indexes, clusters, and sequences
  • 18. Basic Oracle security
  • pt. III. Beyond the basics
  • 19. Advanced security
  • virtual private databases
  • 42. The hitchhiker's guide to the Oracle data dictionary
  • 43. The Hitchhiker's guide to tuning applications and SQL
  • 44. Case studies in tuning
  • 45. The hitchhiker's guide to Oracle Application Server 10g
  • 46. The hitchhiker's guide to database administration
  • 47. The hitchhiker's guide to XML in Oracle

Similar Items