Intro to ORACLE


ORACLE is a fourth generation relational database management system. In general, a database management system (DBMS) must be able to reliably manage a large amount of data in a multi-user environment so that many users can concurrently access the same data. All this must be accomplished while delivering high performance to the users of the database. A DBMS must also be secure from unauthorized access and provide efficient solutions for failure recovery. The ORACLE Server provides efficient and effective solutions for the major database features.

ORACLE consists of many tools that allow you to create an application with ease and flexibility. You must determine how to implement your requirements using the features available in ORACLE, along with its tools. The features and tools that you choose to use to implement your application can significantly affect the performance of your application.

Several of the more useful features available to ORACLE application developers are integrity constraints, stored procedures and packages, database triggers, cost-based optimizer, shared SQL, locking and sequences.

This documentation will lead you through the main features and tools of ORACLE. It is intended to give you a partial view of what is available to you to use within the assignments.

This documentation will cover:

Is ORACLE hard to learn? Not really.
Use this manual to give you an introduction and reference, and peruse whatever code the T.A. gives you, but above all else experiment! No amount of documentation could hope to encapsulate all of the little ins and outs that some good old fashioned fiddling around will find. Try to remember that a few thousand pages were boiled down to this thin tome that you are holding, so if you think that this book is the be-all and end-all of ORACLE knowledge... Well, you'll find out soon enough.

Good luck!