Oracle and OpenEdge objects and terminology
- Last Updated: March 30, 2020
- 1 minute read
- OpenEdge
- Version 12.2
- Documentation
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.
| Oracle schema object | OpenEdge equivalent |
|---|---|
| Table | Table |
| Column | Field |
| Row | Record |
| Index | Index |
| Sequences | Sequences |
| Integrity constraint1 | 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) |
1 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.