Oracle Model

The Oracle Model is a series of Oracle tables that is created from the information in the Source Model. The Oracle Model is displayed in the Oracle Model page of the Navigator Pane. It displays the following:

Check Constraints

Check constraints provide a mechanism for enforcing domain constraints for columns or user-defined types.

Foreign Keys

Foreign keys are the columns or sets of columns included in the definition of a referential integrity constraint.

Indexes

Indexes are optional structures associated with tables that you can create to increase the performance of data retrieval.

Primary Keys

Primary key values defined on a key (a column or set of columns) specify that each row in the table can be uniquely identified by the values in the keys.

Stored Procedures

Stored procedures are Java classes that Oracle stores in the database and that you can call from any application. When you create a stored procedure, Oracle parses the procedure and stores its parsed representation in the database.

Tables

Tables are the basic units of data storage in an Oracle database. The tables of a database hold all of the user-accessible data. Table data is stored in rows and columns.

Views

Views are custom-tailored presentations of the data in one or more tables. Views can also be thought of as stored queries.