|
Oracle in a Nutshell
Introduced a quarter-century ago, the Oracle database remains the leading enterprise relational database management system (RDBMS) in the world. Oracle is a complex system, offering a myriad of products, languages, and tools. Frequent updates, releases, and editions complicate the ability of Oracle users to keep up with the huge amounts of frequently
changing information about the database and its capabilities.
The goal of Oracle in a Nutshell is to bring order to the chaos of Oracle information -- to pull together the most essential information on Oracle architecture, syntax, and user interfaces. The content and format of this book, an admirable addition to O'Reilly's respected In-a-Nutshell line, combine to boil down vital Oracle commands, language constructs, parameters, and file formats in a succinct and highly accessible desktop reference.
Oracle in a Nutshell covers the information that database administrators PL/SQL and Java developers, and system, network, and security administrators need as they manage Oracle databases and write code for these databases. It includes:
* Oracle Foundations--Overview of the Oracle architecture (memory structures and fundamental concepts), Oracle's various editions and packaging options, summary of the initialization file parameters and data dictionary views, and fundamentals of Oracle's concurrency scheme, security mechanisms (privileges, profiles, roles), and networking files (TNSNAMES.ORA, SQLNET.ORA, LISTENER.ORA, DAP.ORA, NAMES.ORA, CMAN.ORA) and options.
* Oracle Languages--Syntax summary for SQL language statements, SQL function calls PL/SQL language statements and characteristics, PL/SQL built-in package headers, and Java (JDBC and SQLJ) interfaces to the Oracle database.
* Oracle Tools--Commands provided with SQL*Plus, SQL*Loader, Import and Export, Oracle Recovery Manager (RMAN) and other backup/recovery methods, Oracle Enterprise Manager, and various performance tuning tools (Explain Plan, TKPROF, AUTOTRACE, UTLBSTAT, UTLESTAT, Statspack).
* Appendixes--Summary of Oracle datatypes, operators, expressions, conditions, numeric and date formats, and resources for additional reading.
Table of Contents:
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 Fundamentals
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
|
