Oracle in a Nutshell
A Desktop Quick Reference. Covers Oracle 9i
(Sprache: Englisch)
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...
Leider schon ausverkauft
versandkostenfrei
Buch
37.51 €
Produktdetails
Produktinformationen zu „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 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.
Klappentext zu „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 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, andfundamentals 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
... mehr
datatypes, operators, expressions, conditions, numeric and date formats, and resources for additional reading.
... weniger
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 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.
Inhaltsverzeichnis zu „Oracle in a Nutshell “
Preface 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.
... mehr
Numeric Formats D. Date Formats E. Additional Resources
... weniger
Autoren-Porträt von Rick Greenwald, David C. Kreines
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 been a principal author of ten 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 Media, Inc., 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 Media, Inc., 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 Kreines is the Manager of Database Services for Rhodia, Inc., and author of Oracle SQL: The Essential Reference (O'Reilly Media, Inc., 2000) and coauthor of Oracle in a Nutshell (with Rick Greenwald) (O'Reilly Media, Inc., 2002), Oracle Database Administration: The Essential Reference (with Brian Laskey) (O'Reilly Media, Inc., 1999) and Oracle Scripts (with Brian Lomasky) (O'Reilly Media, Inc., 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.
Bibliographische Angaben
- Autoren: Rick Greenwald , David C. Kreines
- 2003, 926 Seiten, mit Schwarz-Weiß-Abbildungen, Maße: 15,4 x 23,3 cm, Kartoniert (TB), Englisch
- Herausgegeben: David C. Kreines
- Verlag: O'Reilly Media
- ISBN-10: 0596003366
- ISBN-13: 9780596003364
Sprache:
Englisch
Kommentar zu "Oracle in a Nutshell"
0 Gebrauchte Artikel zu „Oracle in a Nutshell“
Zustand | Preis | Porto | Zahlung | Verkäufer | Rating |
---|
Schreiben Sie einen Kommentar zu "Oracle in a Nutshell".
Kommentar verfassen