Mastering Oracle SQL and SQL*Plus

Book Description

SQL is the ANSI-standard language for accessing and manipulating relational databases. Anyone (programmers, administrators, or designers) who work with a relational databases need to understand the SQL language. While most books on the market do not properly cover the basics, this book differs: it explains fundamentals in detail, supported by realistic examples.You will gain full competence to define, access, and manipulate data in an Oracle database.

This book is an effective tool for you to write effective SQL for the Oracle database. The text is fully compliant with the latest version of the ANSI SQL standard, and fully update for the Oracle 10g database. This book is a translation of popular Netherlands college text (currently in its third edition). Author Lex de Haan is highly experienced with the Oracle database, and has twenty-five years of teaching experience. de Haan is also a member of the ANSI/ISO SQL standardization national body.

Customer Reviews:

Well written and easy to follow.......2005-09-12

What a pleasure to pick up a computer book and finish it.
I was completely new to SQL and was looking for a book that would get me started, this was it.
What impressed me more was when I came upon an obstacle the response I received from the author was quick and informative.

Many thanks Lex

Full of expectations, but..........2005-08-03

Hi

Having read 100's of reviews on SQL*Plus books I finally decided on this book. I felt that I had to give feedback as this book is not as good as the other reviews make it to be. I was looking for a book that specifically contained info on SQL*Plus syntax and a bit of SQL.
I was full of expectations, but ended up being very disappointed. The books does cover SQL and it does cover SQL*Plus, but it never goes into any real depth on either topics. I love real world examples that I can actually refer back to and use on the job. Unfortunately this is not one of those books. If you are not an absolute beginner and can already do a fair bit of SQL/SQL*Plus then this book is not for you.

Very useful CD with 10g.......2005-03-14

The book presupposes no prior knowledge of Oracle SQL, or indeed of any SQL. de Haan writes for someone willing to study alone from this text, without benefit of the classroom.

Ah, but before I go further, I should add that there is one very attractive feature. The book has a CD with Oracle 10g for Microsoft Windows, and an associated Developer's License. You will need to install it to handle the many exercises he poses. (Another plus of the book.) But one can easily imagine an experienced developer getting the book for the CD alone.

Now if you do need to learn Oracle SQL, de Haan proceeds at a careful pace. He gives you the syntax in understandable chunks; not too much to overwhelm. SQL syntax diagrams can be formidable in their full glory. But piece by piece, you should be able to assimilate the content.

de Haan has also tried to keep to standard SQL syntax, as much as possible. At the level of an expected reader of the book, this is probably best. Oracle specific variants (just like other vendors' variants) tend to arise in more advanced contexts.

Helpful and Comprehensive.......2005-02-13

The main reason I love this book is because I can use it to teach someone, at any level, Oracle SQL or SQL*Plus by just pointing to sections and pages as examples. There are comprehensive query examples with Oracle and ANSI/ISO (SQL:2003) syntax, including specific Oracle limitations.

The details on SQL*Plus are excellent and even experts can learn quite a few essential tips. At many points reading the book I was provoked into testing further details on my own, because the approach is clear and helpful and it motivated me to think. A complete and accurate book including theory, syntax, examples, references and gotchas (caution and notes). It also includes 10g Oracle query features.

Great book. My copy gets used at work a lot. :-)

For those who really need SQL.......2005-02-10

This book gets you started as a beginner and takes you all the way to becoming an intermediate SQL expert. Even those who think they know SQL can learn a lot from the book. Lex de Haan is a rare bird: he is both a very good teacher AND a consummate SQL savvy seasoned by industry practice. Lex knows what errors people make and he sets all the traps, to pick you out after you've fallen into them.
And it's up to date with the latest Oracle stuff, without drowning in hype.
The smart exercises and answers make this book ideal for teachers. I've had loads of university students work with the Dutch version, and I've been sorry for the lack of an English equivalent. But here it is at last!

Average customer rating:

For the Intermediate Oracle Developer
Great first SQL book, and useful reference
Inadequate
Good overview of Basic DML & advanced features
An extensive reference, meant for the experienced programmer

Mastering Oracle SQL, 2nd Edition
Sanjay Mishra , and Alan Beaulieu
Manufacturer: O'Reilly Media, Inc.
ProductGroup: Book
Binding: Paperback

Database Management Systems | Databases | Computers & Internet | Subjects | Books

General | Databases | Computers & Internet | Subjects | Books

General | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

General | Programming | O'Reilly | By Publisher | Books

Oracle & Database Programming | Programming | O'Reilly | By Publisher | Books

Look Inside Computer Books | Trip | Specialty Stores | Books
Similar Items:

ASIN: 0596006322

Book Description

The vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle SQL, and perhaps include a few simple examples. It might be enough to pass a survey course, or give you some buzz words to drop in conversation with real Oracle DBAs. But if you use Oracle SQL on a regular basis, you want much more. You want to access the full power of SQL to write queries in an Oracle environment. You want a solid understanding of what's possible with Oracle SQL, creative techniques for writing effective and accurate queries, and the practical, hands-on information that leads to true mastery of the language. Simply put, you want useful, expert best practices that can be put to work immediately, not just non-vendor specific overview or theory. Updated to cover the latest version of Oracle, Oracle 10g, this edition of the highly regarded Mastering Oracle SQL has a stronger focus on technique and on Oracle's implementation of SQL than any other book on the market. It covers Oracle s vast library of built-in functions, the full range of Oracle SQL query-writing features, regular expression support, new aggregate and analytic functions, subqueries in the SELECT and WITH clauses, multiset union operators, enhanced support for hierarchical queries: leaf and loop detection, and the CONNECT_BY_ROOT operator, new partitioning methods (some introduced in Oracle9i Release 2), and the native XML datatype, XMLType. Mastering Oracle SQL, 2nd Edition fills the gap between the sometimes spotty vendor documentation, and other books on SQL that just don't explore the full depth of what is possible with Oracle-specific SQL. For those who want to harness the untapped (and often overlooked) power of Oracle SQL, this essential guide for putting Oracle SQL to work will prove invaluable.

Customer Reviews:

For the Intermediate Oracle Developer.......2007-05-20

The goal of the authors is to explain how to write good readable SQL queries in Oracle 10g. The book starts with how to construct SELECT statements to group, filter and format result sets for dates, reports and data analysis. Then it proceeds to cover Oracle-specific queries and functions for hierarchies (data in tree structures), object-oriented types, XML documents, regular expressions and models (spreadsheet-like objects). Where relevant, there are notes about the differences between SQL for Oracle 10, Oracle 9 and the ANSI standard.

As expected from the title, the chapters using declarative programming (i.e. SQL queries) for relational data, hierarchical data and reports are the most comprehensive. Chapters on interfacing Oracle SQL with other technologies such as scripting (Oracle's PL/SQL), object-oriented types, XML and regular expressions, or on optimization, are brief but sufficient to get you started, especially if you have a existing background in those technologies.

This is the 2nd edition, so it's not surprising that the scope of the book is well-defined and that the writing is easy to read and polished. The example data and queries are just complex enough to demonstrate the issues without obscuring the main points. Minor annoyance about Chapter 15, "SQL Best Practices", which does not explain how to use the query analyzer and bind variables.

I was already familiar with basic Oracle SQL but didn't really understand the language; this book blew away many of the fuzzy concepts in my mind and provided me the framework to tackle more complex problems.

Kam-Hung Soh, 21 May 2007.
[...]

Great first SQL book, and useful reference.......2006-01-12

I'm no SDE, but I had a need to learn enough SQL to enable me to hit my company's Data Warehouse tables directly and employ some complex joins. This was the book recommended to me, and it did the trick. I sat down and began reading it and was quickly writing increasingly complex queries. I found the explanations easy to follow, and the format intuitive. The only fault I found is that there is a lack of more complex join examples, as when there are more than one field being joined on or more than two tables being joined.

Inadequate.......2005-05-12

Half of this 450 page book surveys basic SQL, and the other half is on features Oracle added to SQL in versions 9i and especially 10g. The book seems to have been intentionally "crippled" to limit it to the category of introductory overview, because much of what you need to know to work with Oracle SQL is simply not there:

* Most technical books begin the discussion of each new operation with a syntax diagram. Not this one! All you get here is a code example or two that supports the text.

* There is little discussion of built-in functions beyond the date/time ones.

* The index is very skimpy. It doesn't even contain all the Oracle reserved words that are used in the text. For example, has the use of the SIBLINGS keyword slipped your mind? Don't expect any help looking it up again! Heck, there aren't even entries for DUAL, COMMIT and ROLLBACK, or COUNT() !

* There isn't a single word about materialized views, which is something you will need to know about in the real world.

* There is nothing about triggers.

* There is no discussion of the various Oracle clients available (Toad, SQL*Plus, SQL Navigator, etc)

Ironically, since the book wants to cover all the new extended functionality, some very basic information is included only as it pertains to an advanced topic. For example:

* DDL is generally ignored. This leaves you clueless about the regular CREATE OR REPLACE VIEW (for example) statements that you will encounter and use daily as an Oracle developer. But there's lots of DDL in the sections on classes and objects, hierarchical queries, collections -- stuff that you'll use infrequently if at all.

* There is nothing about performance. Yes, a full discussion of tuning is beyond the scope of an introductory text, but jeez they don't even discuss indexes, except in the section on partitioning!

* There is nothing about relational integrity (or constraints of any kind) except in the section on hierarchical queries.

It's clear O'Reilly wants you to buy this expensive but slim volume as part of a set, probably with another book to provide the rest of the information about SQL; a "nutshell" book to cover syntax and options; a guide to Toad or some other client; a DBA book for basic information about DDL and indexes; a performance/tuning book; and a PL-SQL book.

Another area of major weakness might not bother a reader who is completely new to relational databases. But if you are coming to Oracle from DB2 or SQL Server, this book is not much help. Oracle SQL is only superficially similar to ANSI SQL. Unfortunately, this bookmakes no mention of the things Oracle leaves out. Two big issues for me, were that Oracle won't let you write an outer join that uses both join-conditions and where-conditions; and Oracle has no simple way to insert into one table from a join with another table. I wasted several days in anguished de-bugging of SQL logic that I "knew" worked in all DBMSs -- NOT! (Now I know why Oracle code so often consists of a mess of layers and layers of inline views).

There are other, less-major problems with this book that I might as well pile on:

* There is too much explanation of how things used to be done in 8i. Hello, that version is five years old! If any shop is still running 8i, they have lots of dusty manuals laying around. 8i shouldn't take up more than a paragraph or two in a book that purports to cover 9i and 10g.

* The author's coding style is idiosyncratic, in my opinion. Is it too much to ask that elements at the same logical level be indented to the same number of places??

To sum up, this book is like a series of magazine articles describing *what* can be done with Oracle SQL. But it doesn't do a good job of telling you *how* to do it.

Good overview of Basic DML & advanced features.......2004-12-23

I will agree with other reviewers that cite this book as an excellent resource. It is well organized and easy to follow from topic to topic without getting lost. The examples are well introduced and written with few minor errors. These will be easy to spot for someone who has used any flavor of SQL.

Some issues that I did have with the book revolve around what it isn't. Most of the book revolves around features that are new to 10g rather than a solid overview of the Oracle DML. This means that readers will not be properly introduced to string manipulation outside of the regular expression implementation which is new to 10g (Legacy DBs?). Also, you will have to look elsewhere for good information on CAST, CONVERT and case changing functions. These can be crucial as Oracle is much more strongly typed with regards to data than MS SQL Server.

As DBAs or reporting analysts aren't always privy to the latest release, I see the concentration on 10g's new features as a flaw. Over all this book will introduce you to Oracle SQL in an easy to follow manner. Experienced SQL users will be able to become functional by using this book but, will scratch their heads when they encounter the DML language gaps.

An extensive reference, meant for the experienced programmer.......2004-12-12

The collaborative work of Oracle experts Sanjay Mishra and Alan Beaulieu, Mastering Oracle SQL is now in an expanded and updated second edition covering Oracle Database 10g. An extensive reference, meant for the experienced programmer looking to elevate his or her skill in Oracle SQL to the point of expertise, Mastering Oracle SQL especially focuses upon the software's strengths such as regular expressions, interrow calculations, recursive queries, analytic and advanced GROUP BY functions, and more. Examples, sample code, and detailed walkthroughs for applying Oracle SQL to given tasks and challenges make Mastering Oracle SQL a practical and thorough tool for independent study and professional use.

Average customer rating:

Junk
Average reading
The title should be changed to "Advanced Oracle SQL"
Very good book -- worth the money
Paid for itself in 10 minutes

Mastering Oracle SQL
Sanjay Mishra , and Alan Beaulieu
Manufacturer: O'Reilly
ProductGroup: Book
Binding: Paperback

Database Management Systems | Databases | Computers & Internet | Subjects | Books

General | Databases | Computers & Internet | Subjects | Books

General | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

General | Programming | O'Reilly | By Publisher | Books

Oracle & Database Programming | Programming | O'Reilly | By Publisher | Books

All Titles | Qualifying Textbooks - Fall 2007 | Stores | Books

Computers & Internet | Qualifying Textbooks - Fall 2007 | Stores | Books
Similar Items:

ASIN: 0596001290

Book Description

If you write programs to run against an Oracle database, you spend a lot of time and mental energy writing queries to return the data your programs need. Knowledge of SQL, and particularly of Oracle's implementation of SQL, is the key to writing good queries in a timely manner. In this book, the authors share their knowledge of Oracle SQL, and show you many creative techniques that you can use to advantage in your own applications.

This book shows you how to:

Leverage Oracle's vast library of built-in SQL functions
Query time-based data, and write joins involving date and time ranges
Use Oracle SQL's hierarchical query features to deal with data best represented in a tree format
Use DECODE and CASE to implement conditional logic in your queries
Use Oracle's new, analytic SQL features to write ranking queries, lag and lead queries, windowing queries, and more
Join data from two or more tables using the newly supported SQL92 join syntax

In addition, you'll see how SQL can best be integrated with PL/SQL. You'll also learn various best practices to help you write SQL queries that perform efficiently.

Precious few books on the market today go beyond discussing syntax and the barest rudiments of using Oracle SQL. This book changes that, showing you how to creatively leverage the full power of SQL to write queries in an Oracle environment.

Customer Reviews:

Junk.......2004-05-28

This book only covers basic features in Oracle 8i and there's no example code accompanying the book. PL/SQL is covered in a scant 10 pages and there's no meaningful coverage of large objects or collections.

Given O'Reilly's usual high quality, this book is a surprising miss. My advice: buy another book, there are plenty to choose from.

Average reading.......2004-02-05

It's a good book but it misses a beat here and there on the more difficult topics. It is worth a try, as all the Oracle books are silly.

The title should be changed to "Advanced Oracle SQL".......2004-01-30

I like this book. It covers some advanced topics of Oracle SQL with some good examples. It doesn't cover everything of SQL statements and grammer, but it does teach you some techniques of writing good queries. It's hard to find similar book on the market.

Very good book -- worth the money.......2003-05-09

As a value for the dollar, I give it 5 stars. I think it is most useful to people who have some SQL experience with Oracle and want to take their skills to the next level. I agree with some of the other reviewers that "Mastering" is a bit of a marketing stretch, particularly since there is limited coverage of Oracle optimizer issues. I would also have included some further discussion on how to read and use "Explain Plan" results. With those cavaets, however, I think that almost any SQL programmer will find something in this book to improve their skills. I found the discussion of subqueries to be very useful, as well as the OLAP queries. I read the book cover to cover. It is well written and the concepts are generally presented clearly.

Paid for itself in 10 minutes.......2003-04-19

A clear explaination of how to use multiple nested views has saved the day. I can now run a single query on my large table (the table has 83 Million rows in it) and it completes by in a few hours. I have enjoyed reading it and becoming more experienced in SQL. In the past I would use Perl/DBI to access the database but now I do it through sqlplus because of the large datasets I am working with. I wish I bought this book a loong time ago.

Mastering Oracle PL/SQL: Practical Solutions

Average customer rating:

This is a real good book to master PL/SQL
One for the must have collection !
By far, one of the best book on practical Pl/sql
A good book, worth its price
A disorganized but essential practitioners guide to PL/SQL

Mastering Oracle PL/SQL: Practical Solutions
Connor McDonald , Chaim Katz , Christopher Beck , Joel R. Kallman , and David C. Knox
Manufacturer: Apress
ProductGroup: Book
Binding: Paperback

Database Management Systems | Databases | Computers & Internet | Subjects | Books

General | Databases | Computers & Internet | Subjects | Books

General | Programming | Computers & Internet | Subjects | Books

General | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

Look Inside Computer Books | Trip | Specialty Stores | Books

All Titles | Qualifying Textbooks - Fall 2007 | Stores | Books

Computers & Internet | Qualifying Textbooks - Fall 2007 | Stores | Books
Similar Items:

Accessories:

ASIN: 1590592174

Book Description

PL/SQL is the procedural programming language of choice in the Oracle database. It is completely integrated with SQL and is the most fully optimized, highest performance language for database transaction processing.

This book is about cool, effective techniques to solve essential problems using PL/SQL. It does not attempt to teach the language - there are plenty on the market that do that - instead it focuses in on the fundamental programming unit, the stored procedure, and demonstrates how to code them in the most effective manner and on real practical uses for them in the database.

In short: if you have mastered the fundamentals of the PL/SQL language, and are now looking for an in-depth, practical guide to solving real problems with PL/SQL stored procedures, then this is the book for you. It will demonstrate how to:

- Design efficient, high performance PL/SQL code

- Implement effective data handling mechanisms

- Streamline your database administration

- Work with Triggers

- Secure your data

- Build effective web applications that run from the database

- Exploit the versatile functionality of Java right in the database

- Debug and optimize PL/SQL

This book is targeted primarily at the Oracle DBA or developer charged with the implementation of effective data handling and database administration mechanisms, but will also have great appeal to any developer whose applications rely on an Oracle database and who needs a sound understanding of how to use PL/SQL in order to distribute their application code effectively.

Download Description

NEW from the OakTable Press Series from Apress!

If you need more from a PL/SQL book than just the correct keywords and some pretty syntax diagrams, then this is the book for you. Have you been searching in vain for real-world examples and genuine strategies for maximizing the benefits of PL/SQL within your organization, you'll find them in Mastering Oracle PL/SQL: Practical Solutions, the inaugural title of the pioneering OakTable Press series from Apress.

Mastering Oracle PL/SQL: Practical Solutions isn't a tutorial on how to code PL/SQL. It's designed to show you how to code PL/SQL well. It will show you how to write code that will run quickly and won't break in high load, multi-user environments. It covers the vast array of the functionality that PL/SQL provides, including effective handling of relational and abstract data, security, triggers, dynamic web content presentation from within the database, creation of a DBA toolkit, and effective debugging techniques.

This book sets out to redress the unjust criticism leveled at PL/SQL in years gone by. It gives you the tools and techniques to ensure that, whatever your needs are, the PL/SQL you build will run as efficiently as possible. I am confident the practical solutions provided in this book will help you to realize the true power and functionality PL/SQL can offer your projects.

Mastering Oracle PL/SQL: Practical Solutions is targeted primarily toward the DBA or developer charged with the implementation of effective data handling, security, and database administration mechanisms in the Oracle database. However, it will also have great appeal to any developer whose applications rely on an Oracle database and who needs a sound understanding of how to use PL/SQL effectively,

If you're brand new to PL/SQL, then you'll want to take some time to get familiar with the language before tackling this book. It's not for the total beginner. But once you're up and running, we believe you'll find our book an invaluable guide for ensuring that the PL/SQL solutions you build are robust, perform well, and are easy to maintain.

Customer Reviews:

This is a real good book to master PL/SQL.......2005-10-23

The book is good but many solutions are not tested fully so its not that they can be cut and pasted directly out of the book. you may have to troubleshoot many of them. Otherwise a real good book.

One for the must have collection !.......2005-09-30

As a Developer working predominantly with Oracle Databases for over five years, I'm always looking for books to help me produce better code. I have to say this is one of them. The author has produced a book that explains concepts in a practical manner that is also easy to read. I began reading this book just before starting a major development project and the code insights and examples assisted me greatly in this project.

Probably more a information and guidence book rather than a reference book. I found I read it from cover to cover and used the information as a platform for future developing. Some great code examples which I have used to great effect though!

By far, one of the best book on practical Pl/sql.......2005-09-06

With 15 years experience in Oracle as DBA and developer, I wrote a lot of packages and found in this book true advices and practical solutions, wich sound good to me. The best feature is that you can experiment all the code found in it and see by yourself the advantage of using the way proposed by McDonald. I like these books where autors breaks some common ideas ans show by "A + B" that the right solution is not the most common. A real useful book written by a true professional.

A good book, worth its price.......2005-03-09

The book takes a bottom-up approach: the first part shows useful coding and optimizing techniques, while the second one gives real world applications and tips on program design.

I have two minor complaints, however:

Most chapters assume at least a good knowledge of PL/SQL and build on that, which I think is fair for a book titled "Mastering ...". On the other hand, two of the chapters (Triggers especially, and PL/SQL Debugging to a degree) take a different approach and start from the beginning, explaining the basics, too. It may be just me, but I think those pages are wasted.

Furthermore, there is a certain amount of overlap with Tom Kyte's Expert One-on-One Oracle, also from Apress.

A disorganized but essential practitioners guide to PL/SQL.......2004-10-21

I've had this book for a couple of months now. I've been waiting to finish it before writing a review, but it doesn't look like I'll be finished with it any time soon mostly because I'm using it as a reference book instead of reading it from front to back.

Clearly the book wasn't written as a reference book. Just look up almost any topic in the index and you'll find a number of entries scattered all over the place. Pipe-lined functions, for example, are written about in 4 (four) separate chapters! But the index is good and the material isn't redundant. The reason for this strange structure, I think, is as follows:

The book is divided into two equal length sections. The first half deals in general with PL/SQL strategies and techniques: how to check your code for efficiency, why code should be in packages, how to use cursors, cursor variables, cursor expressions, anchored data types and collections. The second half of the book re-visits most of the same topics in an application centric way (often using PL/SQL supplied packages). It's natural that some of the same techniques and strategies will be re-used and there will be some overlap in the application-oriented chapters.

Sometimes though, the repetition is weird: both the trigger chapter and the security chapter describe a logon trigger that's designed to prevent an ODBC user from accessing the database. The security chapter discusses the data base object grants that are necessary for the trigger to work while the trigger chapter omits all this. The trigger chapter discusses the security risk with the trigger, how a user can often rename the desktop application and bypass the trigger's intent (and purpose) while the security chapter doesn't mention that problem at all.

The book's style (but not its (lack of) organization) is clearly influenced by Tom Kyte's writing, (one of the technical reviewers). Each proposition, especially in the first 1/2 of the book is backed up with a SQL proof/example/argument (based usually on the v$stat view). The style is taken to the max in the discussion of implicit vs. explicit cursors, (in chapter 3). There the discussion stretches over 10 pages and alternates between thesis anti-thesis proof and counter proof like a debate in a Tibetan monastery.

A nice thing is that there's often more than one solution to a problem. For example the code that monitors the Oracle alert file for error messages opens the alert file as an EXTERNAL TABLE, but then an alternate approach is described, which opens the alert file as a BFILE (an external LOB). This is coupled with an explanation about why you might want to go one way or the other, which is very illuminating (although in this specific case, I'm not sure why the author didn't simply open the alert file using utl_file supplied package.)

In my opinion, the chapter describing the PL/SQL Web Toolkit and related technologies is a treasure trove by itself and probably worth the price of the whole book. I don't believe this information is available in such an engaging lucid way anywhere else. It's the only chapter that I had read without stopping.

The book came out as Oracle10g was being released, which raises an important question - is this book already outdated or not? My feeling is that the book is just relevant for 10g PL/SQL developers as 9i developers. The reason I say this is that the PL/SQL language from the developer's point of view has not changed between 9i and 10g (See the paper on OTN 'What's New in PL/SQL in Oracle Database 10g?' which emphasizes that the main changes in PL/SQL 10g - compiler and execution environment - are transparent to the developer.) Maybe, for 10g, the book could have mentioned some of the new PL/SQL supplied packages, for example, dbms_scheduler in addition to dbms_job, or utl_mail instead of utl_smtp, htmldb in addition to the web toolkit, but obviously this has no impact on the book's main message.

What is the book's main message? Demonstrate that the PL/SQL code you write is performant and scalable (chapter 1). The rest of the book is a hodgepodge of technical PL/SQL advice and techniques that should have been organized like a dictionary or an encyclopedia. But nothing is perfect and you can still learn a lot from this eccentric PL/SQL text (even if you can't read it from cover to cover).

Mastering Oracle: Featuring Oracle's SQL Standard

Average customer rating:

Mastering Oracle: Featuring Oracle's SQL Standard
Daniel J. Cronin
Manufacturer: Sams Publishing
ProductGroup: Book
Binding: Paperback

Database Management Systems | Databases | Computers & Internet | Subjects | Books

General | Databases | Computers & Internet | Subjects | Books

General | Programming | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

Look Inside Computer Books | Trip | Specialty Stores | Books
ASIN: 0672484196

Mastering Oracle 7 & Client/Server Computing

Average customer rating:

A very comprehensive and good Oracle 7+ book
On Oracle 7.1--Look for the 2nd Edition (ISBN 0782118402)

Mastering Oracle 7 & Client/Server Computing
Steven M. Bobrowski
Manufacturer: Sybex Inc
ProductGroup: Book
Binding: Paperback

Distributed Databases | Databases | Computers & Internet | Subjects | Books

Database Management Systems | Databases | Computers & Internet | Subjects | Books

General | Databases | Computers & Internet | Subjects | Books

General | Programming | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

Book Description

An insider's guide to the multi-platform architecture of Oracle7. This book offers rich advice for ensuring data integrity, enhancing system security, developing applications, and exploiting Oracle7's client/server architecture. Written by one of the original members of the Oracle7 development team.

Customer Reviews:

A very comprehensive and good Oracle 7+ book.......1998-04-13

I finished reading on this book in September 1996. As a developer, system analyst and team leader among various Oracle projects since 1990, this is the best Oracle book I ever read. It is very easy to understand but deep enough to give you a clear concept about how Oracle 7 fits for Client/Server applications. I bought another Oracle book written by the same author, Oracle 8 Architecture, in December 1997. I have been waiting for the third edition, something like 'Mastering Oracle 8 & Client/Server Computing (and/or Data Warehousing) in the near future', written by the same author. Please !

On Oracle 7.1--Look for the 2nd Edition (ISBN 0782118402).......1996-08-06

Material is a dated by the pace of Oracle releases. I have not reviewed the new edition (June 1996).

Books:

Books Index

Books Home

Recommended Books