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;
Show moreDedication; 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;
Show morePreface 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
Rick Greenwald has been active in the world of computer software for nearly two decades, including stints with Data General, Cognos, and Gupta. He is currently an analyst with Oracle Corporation. He has published seven books and countless articles on a variety of technical topics, and has spoken at conferences and training sessions across six continents. In addition to Oracle in a Nutshell, Rick's books include Oracle Essentials: Oracle9i, Oracle8i, and Oracle8 (principal author with Robert Stackowiak and Jonathan Stern, O'Reilly & Associates, 2001), Oracle Power Objects Developer's Guide (principal author with Kasu Sista and Richard Finklestein, Oracle Press, 1995); Mastering Oracle Power Objects (principal author with Robert Hoskins, O'Reilly & Associates, 1996); Using Oracle Web Server (principal author with many others, Que Publishing, 1997); The Oracle WebDB Bible (principal author with Jim Milbery, IDG Books Worldwide, 1999); and Administering Exchange Server (principal author with Walter Glenn, Microsoft Press, 1999). David C. Kreines is the Manager of Database Services for Rhodia, Inc., a subsidiary of Rhone-Poulenc S.A., and author of Oracle SQL: The Essential Reference (O'Reilly & Associates, 2000) and coauthor of Oracle Database Administration: The Essential Reference (with Brian Laskey) (O'Reilly & Associates, 1999) and Oracle Scripts (with Brian Lomasky) (O'Reilly & Associates, 1998). Dave has worked with Oracle as a developer and database administrator since 1985, on a wide variety of platforms, from PCs to mainframes. He is an Oracle Certified Professional, is certified as a DBA, and has been a frequent contributor to Oracle conferences, user groups, and publications, both in the United States and in Europe. Dave served two terms as president of the International Oracle Users Group -Americas (IOUG-A), and spent ten years on the board of directors.
"In short this is a well-written book that provides a wealth of information in a highly condensed form." - James Robert, Cvu, August 2003
 |
Ask a Question About this Product More... |
|
