Referring to the set of data itself, a specific record of data, and an attribute of a specific record

A specific field which uniquely identifies each specific record within a table, such as an unique order ID for each order that is placed.

The primary key can also be a combination of multiple fields in complex data sets

A specific field that refers to a record $($via its primary key$)$ in another table, such as a unique Customer ID stored for each sales order

Code which can be executed by the system or a database administrator to extract a specific dataset from the database, such as identifying all orders associated with

a specific customer

A query which has been stored by the database application, acting as a virtual table. Also called a Transparent Table

Executable code related to a common database operation that is associated with and stored in the database

A summary of data within a table which allows the system to easily locate specific records without searching the entire table

A specialized programming language utilized to manage or manipulate data stored within a relational database

Oracle's variant of SQL$,$ which includes additional functionality by supporting traditional programming concepts such as variables, conditions, and loops

Options

Foreign Key

Primary key

Table, Row, Field

Structured Query

Language $($SQL$)$

View

Stored Procedure

Procedural Language$/$SQL $($PL$/$SQL$)$

Query

Index

Reset

Submit