Object and SQLJ Object Data Types
Oracle v8 and higher allows you to specify a table type of "Object", and to base the table on an object or SQLJ object abstract data type, so that the table uses the properties of the ADT and the ADT attributes become table columns.
Bitmap Join Indexes
A bitmap join index is a bitmap index described through a join query. It is defined on a base table, and stores the row ids from the base table along with the indexed columns from the joined tables.
Database Packages
In Oracle, packages encapsulate related procedures, functions, and associated cursors and variables together as a unit in the database. Packages usually have two parts, a specification and a body. The specification is the interface with your applications; it declares the types, variables, constants, exceptions, cursors, and subprograms available for use. The body fully defines cursors and subprograms, and so implements the specification.
Oracle Dimensions
In Oracle, the columns of the dimension table are called levels of the dimension hierarchy. These levels can have dependent columns. For example, in the dimension Time, the level Quarter has a dependent column called Number of business days.
Transparent Data Encryption (TDE)
Oracle 10gR2 provides Transparent Data Encryption (TDE), encryption that is transparent for the user.
Clusters
A cluster is a schema object that contains data from one or more tables, which have one or more columns in common. Oracle Database stores together all the rows from all the tables that share the same cluster key.
Database Links
A database link is a schema object in one database that enables you to access objects on another database.
Materialized View Logs
When DML changes are made to master table data, Oracle Database stores rows describing those changes in the materialized view log and then uses the materialized view log to refresh materialized views based on the master table.