Description
Book SynopsisThe goal of this book is to bring order to the chaos of Oracle information - to pull together the most essential information on Oracle architecture, syntax, and user interfaces. It covers Oracle commands, language constructs, parameters, and file formats in a desktop reference.
Trade Review"In short this is a well-written book that provides a wealth of information in a highly condensed form." - James Robert, Cvu, August 2003
Table of ContentsPreface I. Foundations 1. Architecture and Packaging Oracle Instances and Databases The Components of a Database The Components of an Instance Oracle Versions Oracle Packaging 2. Configuration Parameter Files and Types Initialization Parameters 3. Concurrency Concurrency Concepts Oracle and Concurrent User Access 4. Security Authentication Profiles Privileges Privileges and Users Roles Auditing Other Security Features 5. Networking Oracle Networking Fundamentals Configuration Files Networking Management Utilities 6. Data Dictionary Static Data Dictionary Views Dynamic Data Dictionary Views II. Languages 7. SQL Common Keywords and Identifiers Common SQL Clauses Data Definition Statements Data Manipulation Statements 8. Functions Common Keywords and Clauses Aggregate and Analytic Functions Numeric Functions Character Functions Date and Time Functions Conversion Functions Object Functions XML Functions Miscellaneous Functions 9. PL/SQL PL/SQL Fundamentals Header Section Declaration Section Execution Section Exception Section Pragmas Program Units Packages Triggers Calling PL/SQL Functions in SQL Native Compilation of PL/SQL External Procedures Java and PL/SQL 10. PL/SQL Packages 11. Java and Oracle Java Drivers Java in the Oracle Database Data Mapping SQLJ JDBC III. Tools and Utilities 12. SQL*Plus Running SQL*Plus Formatting Text Reports SQL*Plus Format Elements Commands 13. Export and Import Export/Import Fundamentals Common Parameters Export-Only Parameters Import-Only Parameters 14. SQL*Loader Running SQL*Loader Command-Line Parameters Control File 15. Backup and Recovery Backup and Recovery undamentals User-Managed Backup and Recovery Recovery Manager (RMAN) 16. Enterprise Manager Architecture Running Enterprise Manager Enterprise Manager Interface Enterprise Manager Administration Expansion Packs OEMUTIL 17. Performance SQL Optimization EXPLAIN PLAN TKPROF AUTOTRACE Statistics Collection IV. Appendixes A. Datatypes B. Expressions, operators, and Conditions C. Numeric Formats D. Date Formats E. Additional Resources
