value
(1) The alpha or numeric content of a field or variable.
(2) The smallest unit of data manipulated in SQL.
(3) A specific data item at the intersection of a column and a row.
variable
A data element that specifies a value that can be changed.
variable-length string
A character, graphic, or binary string whose length is not fixed but can range within set limits. Also referred to as a
varying length string .
version recovery
The restoration of a previous version of the database, using an image that was created during a backup operation.
view
(1) A logical table that consists of data generated by a query. A view is based on an underlying set of base tables, and the data in a view is determined by a
SELECT statement that is run on the base tables. Contrast with
base table .
(2) A way of looking at the information about or contained in objects. Each view might reveal different information about its objects.
Visual Explain
A tool that provides a graphical interface for database administrators and application programmers to display and analyze detailed information on the access plan of a given SQL statement. The tasks provided by this tool can be accessed from the Control Center.
volatile table
A table for which SQL operations choose index access whenever possible.