Oracle in a Nutshell

A Desktop Quick Reference

By Rick Greenwald, David C. Kreines
December 2002
Pages: 926
Series: In a Nutshell
ISBN 10: 0-596-00336-6 | ISBN 13: 9780596003364
(3) (Average of 3 Customer Reviews)

Book description

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.
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 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.

Post-purchase benefits:

Browse within this book

| Table of Contents | Index | Sample Chapter | Colophon

Book details

First Edition: December 2002
Series: In a Nutshell
ISBN: 0-596-00336-6
Pages: 926
Average Customer Reviews: (3) (Based on 3 Reviews)

Featured customer reviews

Oracle in a Nutshell Review, March 25 2004

Rating:

Submitted by robert young [Respond | View]

save for the UML book, this is least useful text O'Reilly has ever published. i get better information just Googling.

Oracle in a Nutshell Review, August 26 2003

Rating:

Submitted by Marc Grundfest [Respond | View]

This book could use some improvement. Overall it is good but it fails to take into acccount that not all parts of oracle need to be included in a quick ref.

In particular it tends to ignore the bread and butter of pro-cobol proc

and odbc in favor of more trendy JDBC JSQL etc. This might be forgivable but to include very damn oracle package notwithstanding how likely they are to be usefull to an application programer is not. The book starts to look more like an oracle feature list for presales than a handbook to surive in the trenches. This makes the book far less usefull for me than I had hoped. I expect that I will keep looking for that handbook.

Oracle in a Nutshell Review, March 20 2003

Rating:

Submitted by Connie Zhao, Pittsburgh, PA [Respond | View]

Excellent Reference

As an Oracle developer, I have been frustrated reading all the Oracle documentations. It's hard to locate what you want to know in those big and thick documentations. I was thrilled to find this book -- it really is a great reference and it can basiclly replace my collection of some other Oracle books. This book is very well-organized into different topics including architecture, data dictionary, SQL, PL/SQL, JAVA and much more. Some topics like PL/SQL and Java, (imagine they are in one book!) look more like a dictionary. You can easily look up for the systax/commands. It gives you a few lines coding as example followed by a brief explaination --All in a concise manor. ( I believe the author has spent considerable time and effort not only in writing the book to make it as complete as possible but also in oragzating each topic in a logical and easy to follow way. ).

Bottom line, this is a very comprehensive resource covering lots of topics, pretty much whatever you need is all in there, in one book!! I have been benefit a lot from having this book at my desktop for quick and easy reference.

Read all reviews

Media reviews

"If you already understand concepts behind the Oracle database, and generally know the tasks you want to perform but can't always remember the steps and utilities involved, then this book is for you. Authors Rick Greenwald and David Kreines present a comprehensive, 900-page desktop reference discussing all aspects of the Oracle database."--Oracle Magazine, April 22, 2003
http://otn.oracle.com/oramag/oracle/03-may/o33vendornews.html

"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."--DBA, March, 2003

Hide extended reviews