Re: Oracle books on Oracle8

If you prefer some e-reference, I think you may first have a look at this:
(learn Oracle in 21 days)
http://member.netease.com/~andymsj/ora21/

and if you want to start with the Oracle document, I suggest you first read the "Oracle Concept", and "Oracle Admin" book.

I think the concept of Access and Oracle differ a lot.

as to :
creating tables: Oracle is just a standard SQL like: create table XYZ ...

creating links betweeb tables: do you mean reference (master/detail table?), if that, see the "create table" sql help.

creating lookup tables: I am not sure what is this in Access. But Oracle has index to speedup table lookup. such as: create index XYZ on table/column...

creating queries: is that just a SQL? you may use "procedures" in Oracle if you want to save a complex query in database.

creating forms: seems Oracle do not have this. I do not know what a "form" is in Access. But there is "view" in Oracle, which is based on tables, but do not have data stored. When you query againt a view, the DB will translate the query to its underlying tables.

Hope these helpful. :-)

By the way, you may find an Oracle GUI tool named "Oracle Enterprise Management" that provide GUI access to the Database. Using it, you do not need to write SQLs by hand, just drag and click. (PS: I am not sure how about your personal edition Oracle.) Received on Wed Mar 20 2002 - 09:26:31 CET