Oracle in a Nutshell

個数:

Oracle in a Nutshell

  • 提携先の海外書籍取次会社に在庫がございます。通常3週間で発送いたします。
    重要ご説明事項
    1. 納期遅延や、ご入手不能となる場合が若干ございます。
    2. 複数冊ご注文の場合、分割発送となる場合がございます。
    3. 美品のご指定は承りかねます。
  • 【入荷遅延について】
    世界情勢の影響により、海外からお取り寄せとなる洋書・洋古書の入荷が、表示している標準的な納期よりも遅延する場合がございます。
    おそれいりますが、あらかじめご了承くださいますようお願い申し上げます。
  • ◆画像の表紙や帯等は実物とは異なる場合があります。
  • ◆ウェブストアでの洋書販売価格は、弊社店舗等での販売価格とは異なります。
    また、洋書販売価格は、ご注文確定時点での日本円価格となります。
    ご注文確定後に、同じ洋書の販売価格が変動しても、それは反映されません。
  • 製本 Paperback:紙装版/ペーパーバック版/ページ数 910 p.
  • 言語 ENG
  • 商品コード 9780596003364
  • DDC分類 005.7565

Full Description

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 combine to boil down vital Oracle commands, language constructs, parameters, and file formats in a succinct and highly accessible desktop reference. The book 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).

Contents

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. Numeric Formats D. Date Formats E. Additional Resources