Synopses & Reviews
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 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.
The 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.
Includes bibliographical references (p. 853-855) and index.
About the Author
Robert Stackowiak is Vice President of Business Intelligence in Oracle's Technology Business Unit. He has worked for over 20 years in business intelligence, data warehousing, and IT-related roles at Oracle, IBM, Harris Corporation, and the U.S. Army Corps of Engineers. His papers regarding business intelligence and computer and software technology have appeared in publications such as "President and CEO Magazine," "Database Trends and Applications," and The Data Warehousing Institute's publications. He also co-authored the books "Oracle Essentials: Oracle Database 10g" (currently in 3rd Edition, February 2004, O'Reilly), "Oracle Application Server 10g Essentials" (1st Edition, August 2004, O'Reilly), and "Professional Oracle Programming" (1st Edition, June 2005, WROX).
Joseph Rayman leads the Oracle Consulting Business Intelligence Practice in North America with over 20 years of business experience in a vast array of industries, including financial services, manufacturing, retail, telecommunications, healthcare, and federal government. His technical and business leadership spans enterprise architecture design, enterprise data modeling, VLDB system tuning, data warehouse design, data mining, and quality assurance activities for data warehouse practices. Joe is a key contributor in defining and authoring Oracle Consulting's Data Warehousing Methodology. Prior to joining Oracle, Joe designed and deployed business intelligence and statistical analysis solutions for a large food manufacturer and provided real-time trading and analysis solutions for a major international financial organization.
Rick Greenwald has worked in the IT field for over 20 years for major vendors, includingOracle, Gupta Technologies, Cognos, and Data General. He has coauthored more than a dozen books, including "Oracle Essentials: Oracle Database 10g" (currently in 3rd Edition, February 2004, O'Reilly), "Oracle Application Server 10g Essentials" (1st Edition, August 2004, O'Reilly), and "Professional Oracle Programming" (1st Edition, June 2005, WROX). Mr. Greenwald currently works for Ingres Corporation.
Table of Contents
Dedication; Preface; Which Platform and Version?; Structure of This Book; Conventions Used in This Book; Comments and Questions; Acknowledgments; Foundations; Chapter 1: Architecture and Packaging; 1.1 Oracle Instances and Databases; 1.2 The Components of a Database; 1.3 The Components of an Instance; 1.4 Oracle Versions; 1.5 Oracle Packaging; Chapter 2: Configuration; 2.1 Parameter Files and Types; 2.2 Initialization Parameters; Chapter 3: Concurrency; 3.1 Concurrency Concepts; 3.2 Oracle and Concurrent User Access; Chapter 4: Security; 4.1 Authentication; 4.2 Profiles; 4.3 Privileges; 4.4 Privileges and Users; 4.5 Roles; 4.6 Auditing; 4.7 Other Security Features; Chapter 5: Networking; 5.1 Oracle Networking Fundamentals; 5.2 Configuration Files; 5.3 Networking Management Utilities; Chapter 6: Data Dictionary; 6.1 Static Data Dictionary Views; 6.2 Dynamic Data Dictionary Views; Languages; Chapter 7: SQL; 7.1 Common Keywords and Identifiers; 7.2 Common SQL Clauses; 7.3 Data Definition Statements; 7.4 Data Manipulation Statements; Chapter 8: Functions; 8.1 Common Keywords and Clauses; 8.2 Aggregate and Analytic Functions; 8.3 Numeric Functions; 8.4 Character Functions; 8.5 Date and Time Functions; 8.6 Conversion Functions; 8.7 Object Functions; 8.8 XML Functions; 8.9 Miscellaneous Functions; Chapter 9: PL/SQL; 9.1 PL/SQL Fundamentals; 9.2 Header Section; 9.3 Declaration Section; 9.4 Execution Section; 9.5 Exception Section; 9.6 Pragmas; 9.7 Program Units; 9.8 Packages; 9.9 Triggers; 9.10 Calling PL/SQL Functions in SQL; 9.11 Native Compilation of PL/SQL; 9.12 External Procedures; 9.13 Java and PL/SQL; Chapter 10: PL/SQL Packages; 10.1 DBMS_ALERT; 10.2 DBMS_APPLICATION_INFO; 10.3 DBMS_APPLY_ADM; 10.4 DBMS_AQ; 10.5 DBMS_AQADM; 10.6 DBMS_AQELM; 10.7 DBMS_CAPTURE_ADM; 10.8 DBMS_DDL; 10.9 DBMS_DEBUG; 10.10 DBMS_DEFER; 10.11 DBMS_DEFER_QUERY; 10.12 DBMS_DEFER_SYS; 10.13 DBMS_DESCRIBE; 10.14 DBMS_DISTRIBUTED_TRUST_ADMIN; 10.15 DBMS_FGA; 10.16 DBMS_FLASHBACK; 10.17 DBMS_HS; 10.18 DBMS_HS_PASSTHROUGH; 10.19 DBMS_IOT; 10.20 DBMS_JOB; 10.21 DBMS_LDAP; 10.22 DBMS_LIBCACHE; 10.23 DBMS_LOB; 10.24 DBMS_LOCK; 10.25 DBMS_LOGMNR; 10.26 DBMS_LOGMNR_CDC_PUBLISH; 10.27 DBMS_LOGMNR_CDC_SUBSCRIBE; 10.28 DBMS_LOGMNR_D; 10.29 DBMS_LOGSTNDBY; 10.30 DBMS_METADATA; 10.31 DBMS_MGWADM; 10.32 DBMA_MGWMSG; 10.33 DBMS_MVIEW; 10.34 DBMS_OBFUSCATION_TOOLKIT; 10.35 DBMS_ODCI; 10.36 DBMS_OFFLINE_OG; 10.37 DBMS_OFFLINE_SNAPSHOT; 10.38 DBMS_OLAP; 10.39 DBMS_ORACLE_TRACE_AGENT; 10.40 DBMS_ORACLE_TRACE_USER; 10.41 DBMS_OUTLN; 10.42 DBMS_OUTLN_EDIT; 10.43 DBMS_OUTPUT; 10.44 DBMS_PCLXUTIL; 10.45 DBMS_PIPE; 10.46 DBMS_PROFILER; 10.47 DBMS_PROPAGATION_ADM; 10.48 DBMS_RANDOM; 10.49 DBMS_RECTIFIER_DIFF; 10.50 DBMS_REDEFINITION; 10.51 DBMS_REFRESH; 10.52 DBMS_REPAIR; 10.53 DBMS_REPCAT; 10.54 DBMS_REPCAT_ADMIN; 10.55 DBMS_REPCAT_AUTH; 10.56 DBMS_REPCAT_INSTANTIATE; 10.57 DBMS_REPCAT_RGT; 10.58 DBMS_REPUTIL; 10.59 DBMS_RESOURCE_MANAGER; 10.60 DBMS_RESOURCE_MANAGER_PRIVS; 10.61 DBMS_RESUMABLE; 10.62 DBMS_RLS; 10.63 DBMS_ROWID; 10.64 DBMS_RULE; 10.65 DBMS_RULE_ADMIN; 10.66 DBMS_SESSION; 10.67 DBMS_SHARED_POOL; 10.68 DBMS_SNAPSHOT; 10.69 DBMS_SPACE; 10.70 DBMS_SPACE_ADMIN; 10.71 DBMS_SQL; 10.72 DBMS_STATS; 10.73 DBMS_STORAGE_MAP; 10.74 DBMS_STREAM_ADM; 10.75 DBMS_STREAMS; 10.76 DBMS_SYSTEM; 10.77 DBMS_TRACE; 10.78 DBMS_TRANSACTION; 10.79 DBMS_TRANSFORM; 10.80 DBMS_TTS; 10.81 DBMS_TYPES; 10.82 DBMS_UTILITY; 10.83 DBMS_WM; 10.84 DBMS_XDB; 10.85 DBMS_XDBT; 10.86 DBMS_XDB_VERSION; 10.87 DBMS_XMLDOM; 10.88 DBMS_XMLGEN; 10.89 DBMS_XMLPARSER; 10.90 DBMS_XMLQUERY; 10.91 DBMS_XMLSAVE; 10.92 DBMS_XMLSCHEMA; 10.93 DBMS_XPLAN; 10.94 DBMS_XSLPROCESSOR; 10.95 DEBUG_EXTPROC; 10.96 OUTLN_PKG; 10.97 UTL_COLL; 10.98 UTL_ENCODE; 10.99 UTL_FILE; 10.100 UTL_HTTP; 10.101 UTL_INADDR; 10.102 UTL_RAW; 10.103 UTL_REF; 10.104 UTL_SMTP; 10.105 UTL_TCP; 10.106 UTL_URL; Chapter 11: Java and Oracle; 11.1 Java Drivers; 11.2 Java in the Oracle Database; 11.3 Data Mapping; 11.4 SQLJ; 11.5 JDBC; Tools and Utilities; Chapter 12: SQL*Plus; 12.1 Running SQL*Plus; 12.2 Formatting Text Reports; 12.3 SQL*Plus Format Elements; 12.4 Commands; Chapter 13: Export and Import; 13.1 Export/Import Fundamentals; 13.2 Common Parameters; 13.3 Export-Only Parameters; 13.4 Import-Only Parameters; Chapter 14: SQL*Loader; 14.1 Running SQL*Loader; 14.2 Command-Line Parameters; 14.3 Control File; Chapter 15: Backup and Recovery; 15.1 Backup and Recovery Fundamentals; 15.2 User-Managed Backup and Recovery; 15.3 Recovery Manager (RMAN); Chapter 16: Enterprise Manager; 16.1 Architecture; 16.2 Running Enterprise Manager; 16.3 Enterprise Manager Interface; 16.4 Enterprise Manager Administration; 16.5 Expansion Packs; 16.6 OEMUTIL; Chapter 17: Performance; 17.1 SQL Optimization; 17.2 EXPLAIN PLAN; 17.3 TKPROF; 17.4 AUTOTRACE; 17.5 Statistics Collection; Appendixes; Datatypes; Scalar Datatypes; Collection Datatypes; Reference Datatypes; Expressions, Operators, and Conditions; Expressions; Operators; Conditions; Numeric Formats; Date Formats; Additional Resources; Web Sites; Books; Colophon;