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.