Oracle in a Nutshell

By L. Joyce Arntson and Lora Brunello Todesco

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.

• Format: Paperback
• Language: English
• ISBN: 0596003366
• ISBN13: 9780596003364
• Release Date: January 2003
• Publisher: O'Reilly Media
• Length: 928 Pages
• Weight: 2.40 lbs.
• Dimensions: 1.7" x 6.1" x 9.2"

Customer Reviews

Good for beginners

Comeing from Coldfusion and Action script, this book was just the right thing for me to get started with java. Its still a long way but this book definitly helped me a lot!

Down to earth very easy to understand

This is my third Demystified book and I haven't been disappointed at all. All are an easy read and full of just the code you need to get programming quickly. I knew nothing about Java nor programming before reading this. Now I can program in Java. Don't be mislead. It is not an end all book. But it has just the right blend of Java to make you productive right away by building useful applications.

Very good way to learn Java

It seems to cover everything you need to become productive right away. The tech jargon is kept to a minimum. Everything is explained for you. You can follow along with examples using your computer. I simply copy the examples and then change them to the specs the Prof wants for homework. Worth the dollars.

Agree with Brin, teaches you, does not throw jargon at you

Recently I was in a Java class. We had 60 students and the professor had no time to stop and answer questions. My friends and I were lost and few places to turn. One of my friends stubled across this book. What a great fine. It answered all the questions the professor didn't answer.

Great book for anyone having a difficult time learning Java

Pros probably stay away from this book. However, I've taken a Java course and the teach couldn't express Java programming concepts in clear English. Thank goodness for this book because I don't think I'd pass the course. I highly recommend this book.