Filter
Top Products
Column
A constituent element of a table. A relational database represents data using two-dimensional tables consisting of
rows and columns.
Column name (item name)
A column name is the name assigned to a column, defined in the schema definition. The column name is used in SQL
statements for data manipulation to specify a column to be processed.
Commit
Makes the data manipulation of a transaction being processed take effect. The data manipulation in the transaction is
physically reflected in the database. An application program deliberately controls a commit by issuing a COMMIT
statement.
Related term: rollback
Comparison predicate
The comparison predicate is a search condition specified using the comparison operators =, <, <=, >, >=, and <>.
Connection
Connection refers to the relationship that connects a client to a server. A connection is made by specifying a
CONNECT statement in an application program. Conversely, a DISCONNECT statement cuts off the connection.
Correlation name
Correlation names are table names used by SQL statements for data manipulation to manipulate data. A correlation
name is valid only for the SQL statement for which it is specified.
Cursor
A cursor is an indicator that indicates a row to be manipulated. A cursor is defined by a cursor declaration statement.
The OPEN and CLOSE statements start and stop cursor operations, respectively. The FETCH statement moves the
cursor.
Cursor SQL statement
A cursor SQL statement is a data manipulation SQL statement that uses a cursor to specify rows to be manipulated.
Data manipulation SQL
A data manipulation SQL is an SQL statement used to reference, add, delete, or update a data base.
208