Filter
Top Products
Target specification
A target specification is used to fetch values stored in a database to an application program. The target specification is
specified as a variable.
Trigger definition
A trigger definition defines the data manipulation (insertion) of a table linked to the data manipulation (insertion,
deletion, update) of another table.
Unique constraint
A constraint on a table or column. This constraint requires that a table cannot have multiple rows having the same
value in a column or combination of columns.
Updatable cursor
In an SQL data manipulation statement, a cursor that can be used to update and delete is called an updatable cursor.
The cursor declaration specifies whether a cursor is updatable. For example, if a table specified in the FROM clause
of a query specification satisfies just one condition, the cursor is an updatable cursor.
Related term: read-only cursor
UPDATE statement
The UPDATE statement is an SQL data manipulation statement used to update data in rows of tables.
Value expression
A value expression is a column specification, variable specification, set function, or literal, or a specification in which
arithmetic operators (+, -, *, and /) are used to combine these items.
Value specification
A value specification, specified from an application program, specifies a value to be stored in, or compared with, a
value stored in a data base. A value specification can be specified with a variable specification, literal (numeric,
character-string, or national-language character-string), the keyword USER, or a dynamic parameter specification.
WHERE clause
In an SQL data manipulation statement, the WHERE clause is a search condition that specifies rows to be
manipulated.
218