Appendix D

Glossary of Terms

abstract data type A user-defined data type that allows you to define operations explicitly (in methods).

administrator In this book, the administrator refers to the database administrator (DBA) who has the DBA role. See DBA.

aggregate functions A function that returns a result based on multiple rows.

alias A temporary substitute for a name in a query. There can be table aliases and column aliases.

alphanumeric A data type that will accept a combination of characters as well as numbers.

anomaly An undesirable consequence of a data modification.

anonymous block A set of PL/SQL statements that may be used to perform a series of tasks using the PL/SQL language.

attribute Columns in a table or relation are called attributes. ...

Get Practical Guide to using SQL in Oracle now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.