Re: New to Oracle

Thanks very much, I actually would like to know:

"the very significant differences between the underlying architectures of Oracle vs DB2".

beside how indexes are organize, authority to create database, table, table indexes. I also looking into SYS tables (the same as looking into SYSIBM tables for DB2).
I understand that data types is somwhat different between the two.

The link that you point to me is more structure and easier to navigate than search thru the whole manual (more relational to me!).

Thanks again

> Oracle vs DB2:
"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news: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
> 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 Sat Oct 25 2003 - 14:18:48 CEST