Home / 12c / Oracle Database 12c Objects

Oracle Database 12c Objects

Each RDBMS supports a various of database objects. Oracle Database 12c supports the entire set of database objects required for a relational and object-relational database, such as tables, views, constraints, and so on. It also supports a wide range of objects specific to the Oracle database, such as packages, sequences, materialized views, and so on. Below table lists the major commonly used objects in Oracle Database 12c.

Oracle Database 12c Objects
Object Type Description
Table A table is the basic form of data storage. A table has columns and stores rows of data.
index An index is an optional structure that is useful for fetching data faster.
View A view is a stored query. No data-storage space is occupied for view data.
Materialized view Materialized views are used to summarize and store data. They are similar to views but take up storage
space to store data.
Index-organized table An index-organized table stores the table data along with the index, instead of storing table and index separately.
Cluster A cluster is a group of tables sharing a common column. The cluster stores the rows of the tables together with the common columns stored once.
Constraint A constraint is a stored rule to enforce data integrity.
Sequence A sequence provides a mechanism for the continuous generation of numbers
Synonym A synonym is an alias for a database schema object.
Trigger A trigger is a PL/SQL program unit that is executed when an event occurs.
Stored function Stored functions are PL/SQL programs that can be used to create user-defined functions to return a value.
Stored procedure Stored procedures are PL/SQL programs to define a business process.
Package A package is a collection of procedures, functions, and other program constructs.
Java Stored Java procedures can be created in Oracle to define business processes.
Database link Database links are used to communicate between databases
to share data.


Check Also


Oracle Database 12c – How to Add / Multiplex Control Files

PURPOSE: – protect your Database in case of a disk failure – reduce the risk …


Oracle Database 12c Release 1 (12.1) Installation on Oracle Linux 7 (OL7.2)

Note from Oracle Database 12c R1 Installation Guide: Starting with Oracle Database 12c Release 1 …

Leave a Reply