By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,501 Members | 1,859 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,501 IT Pros & Developers. It's quick & easy.

ASP programmer looking for Oracle 9i book to get started

P: n/a
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!
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
Jul 19 '05 #2

P: n/a
go to asktom.oracle.com
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" <sc******@cableone.net> wrote in message
news:4a**************************@posting.google.c om...
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!

Jul 19 '05 #3

P: n/a
I reccomend Guide to Oracle9i (isbn:0619159596). 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" <sc******@cableone.net> wrote in message
news:4a**************************@posting.google.c om...
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!

Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.