Re: New to Oracle

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 24 Oct 2003 06:26:48 -0700
Message-ID: <1067002024.263103_at_yasure>


johnlinh wrote:

>Hi:
>I am from DB2 camp. I have just started to learn Oracle by download and
>install Oracle 8.1.7 client, connect to an existing Oracle DB. I also
>downloaded Oracle manual and walking thru it. I have tested what I have
>learned PS/SQL SQL/PLUS. Is there any site/book that I can compare Oracle
>functions with DB2? I would like to start from application development,
>building tables, tuning indexes (by looking into system tables),.... Your
>suggestion would be appreciated.
>
>
>
Can't think of anything specific to DB2 to Oracle though it may well exist. But I would strongly urge
you to go to http://tahiti.oracle.com and look at the CONCEPTS books. Be sure you understand
the very significant differences between the underlying architectures of [Quoted] Oracle vs DB2: They are
completely different.

On the other hand converting PREVVAL to CURRVAL will be just about everything you will
need to learn about sequences.

Welcome.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Fri Oct 24 2003 - 15:26:48 CEST

Original text of this message