Oracle and OpenEdge objects and terminology

Oracle and OpenEdge databases share the structural elements common to relational databases, but each system has its own elements. These structural elements are called schema objects in Oracle and database objects in OpenEdge. Schema objects or database objects are components of the database's logical structure. The two database management systems have different terminology for referring to these objects, as shown in the following table.

Table 4. Oracle and OpenEdge objects
Oracle schema object	OpenEdge equivalent
Table	Table
Column	Field
Row	Record
Index	Index
Sequences	Sequences
Integrity constraint¹	Validation expression
No equivalent	Validation message
Trigger	Trigger
Stored procedures	Stored procedures (SQL Engine)
View	View (SQL Engine)
Clusters	No equivalent
Oracle Object methods	No equivalent
Synonyms	Synonyms (SQL Engine)

¹ The Oracle Integrity constraint enforces data integrity and business rules. However, unlike ABL validation expression, you cannot include code in the integrity constraint. You choose one of the following checks: NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, or CHECK.