Introduction Book for Oracle

We are running a Peoplesoft system and are migrating from MSServer2000 database to Oracle 10g.

I would like to get a recommendation for a book that gives and overview of Oracle (We wont be getting any training).

Im not interested in the DBA side but would like a general overview of the database, for example Oracle use something called tablespaces.

We will not be using PL/SQL but we will need to know about Oracle specific SQL statements from a developer point of view.

I have a couple of books that give an overview (these are based on version 9 but I guess there is not much change to v10?), these are:

Oracle in a nutshell
Oracle 9i for Dummies.

What can you recommend?

Thanks.

10g Concept Manual is a good one.

Tamil

+1 for the Concepts Guide.

The Oracle documentation is excellent, and you might also go and hang around at http://asktom.oracle.com for a few minutes per day.

The optimizer is a big topic that is worth understanding, and Jonathan Lewis has just had a book published on the subject that would be worth picking up.

I suggest you, if you can, program your batch jobs using PL/SQL and not peoplecode

Quote:

---

Originally Posted by pando

I suggest you, if you can, program your batch jobs using PL/SQL and not peoplecode

---

Jason will be using SQR, a unique product from Peoplesoft. It has much more features compared with PL/SQL.

Tamil