Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Overview

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.

Subscriber Reviews

Average Rating: 1 out of 5 rating Based on 1 Rating

"Oracle in a Nutshell" - by modotx on 07-MAR-2010
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
On Page 841, the statement that case expressions are new to Oracle9i is wrong.  Case Expressions have been supported in Oracle since version 8i.  It was the case statement that was introduced in 9i.  This was so that it could be used with cursors as opposed to just being embedded in a SQL statement.

Such a glaring mistake makes me wonder about the real quality of this and other recently released O'Reilly books.

Quit hiring technically ignorant proofreaders to do the job of seasoned technical writers.  Doing so has irreparably damaged your brand.

Report as Inappropriate

Table of Contents

 

Extras

The publisher has provided additional content related to this title.


Description
Content

Visit the catalog page for Oracle in a Nutshell

  • Catalog Page

Visit the errata page for Oracle in a Nutshell

  • Errata