ASP programmer looking for Oracle 9i book to get started

[dSchwartz]

I'm an ASP/ASP.NET/MS SQL server guy looking for a good book to start
me off with Oracle 9i. I'm a computer science senior and have a web
project for a local client coming up which will use Oracle 9i as the
database. I'm looking for a book that will get me started with
Oracle, but I don't need a total SQL beginners guide, I already write
SQL for MS SQL server, but i don't know how different it will be for
Oracle? Any suggestions? Thanks!

[Hans Forbrich]

Re: ASP programmer looking for Oracle 9i book to get started

dSchwartz wrote:

I'm an ASP/ASP.NET/MS SQL server guy looking for a good book to start
me off with Oracle 9i. I'm a computer science senior and have a web
project for a local client coming up which will use Oracle 9i as the
database. I'm looking for a book that will get me started with
Oracle, but I don't need a total SQL beginners guide, I already write
SQL for MS SQL server, but i don't know how different it will be for
Oracle? Any suggestions? Thanks!

Two books to start:

O'Reilly: Oracle Essentials http://www.oreilly.com/catalog/oressentials3/

and

APress: Expert One on One Oracle (by Thomas Kyte)
ISBM: 1590592433

Plan on unlearning a whole bunch! The SQL is pretty similar, but the
differences (eg: in the locking engine) require a completely different
thought process in approaching a problem. If you try the same approach
as you used with SQL Server you will [frequently] end up with a
surprisingly slow solution that has between 2 and 5 times the code that
you need.

The first book helps understand the general internals and is a fairly
light read. It's useful in catching the new and overloaded terminology.
, thus making the actual documentation at http://docs.oracle.com
understandable.

The second book actually starts you down the path of 'thinking in
Oracle' - mandatory reading!

/Hans

[Jim Kennedy]

Re: ASP programmer looking for Oracle 9i book to get started

go to asktom.oracle.c om
Tom's books are excellent as is his web site. The problem won't be the sql
syntax; it will be the difference between how they work. Oracle!=SQL Server
Jim
"dSchwartz" <schwartz@cable one.netwrote in message
news:4ae1ece2.0 402192102.6df11 9c4@posting.goo gle.com...

I'm an ASP/ASP.NET/MS SQL server guy looking for a good book to start
me off with Oracle 9i. I'm a computer science senior and have a web
project for a local client coming up which will use Oracle 9i as the
database. I'm looking for a book that will get me started with
Oracle, but I don't need a total SQL beginners guide, I already write
SQL for MS SQL server, but i don't know how different it will be for
Oracle? Any suggestions? Thanks!

[Seth Stevens]

Re: ASP programmer looking for Oracle 9i book to get started

I reccomend Guide to Oracle9i (isbn:061915959 6). It has some very basic SQL
review at the beginning but then moves into the details of Oralce with
PL/SQL and goes over things like forms bulider and reports builder. Good
Luck!


"dSchwartz" <schwartz@cable one.netwrote in message
news:4ae1ece2.0 402192102.6df11 9c4@posting.goo gle.com...

I'm an ASP/ASP.NET/MS SQL server guy looking for a good book to start
me off with Oracle 9i. I'm a computer science senior and have a web
project for a local client coming up which will use Oracle 9i as the
database. I'm looking for a book that will get me started with
Oracle, but I don't need a total SQL beginners guide, I already write
SQL for MS SQL server, but i don't know how different it will be for
Oracle? Any suggestions? Thanks!