ORACLE

Working With Oracle on Windows: Part 2

Now we have installed Oracle we can now begin to familiarise ourselves with use of SQL and how to use basic Oracle expressions.

Author Info:

By: Ben Shepherd

Poor Best

Rating:

/ 13

March 04, 2003

TABLE OF CONTENTS:

· Working With Oracle on Windows: Part 2
· Databases
· Relationships
· Structuring your database
· Tables in Oracle
· User Defined Schema Objects
· Conclusion

The Oracle database is, without a doubt, the most powerful and sophisticated database available. The latest of these databases are Oracle 9i database release 2, which is available in the Oracle 9i Standard Edition (for the average size applications), Oracle 9i Database Enterprise Edition (for large and powerful applications) and Oracle 9i Database Personal Edition (for the desktop).

A special feature in the standard edition is that to upgrade to the larger and more sophisticated Enterprise Edition, you simply install the Enterprise Edition. This means that you don’t need to alter your database in any way.

In this article, the focus is mainly on the Oracle 9i database itself. Later on in this series of articles on Oracle, I will discuss other new features. The focus of this article is mainly on creating a database in Oracle and some issues that need attention before doing so.

See http://otn.oracle.com/products/oracle9i/pdf/9idb_rel2_prod_fam.pdf for the latest about Oracle 9i and its fantastic features.

Next: Databases >>