Inserting a Row |
||||||||
Sheila can use the Object Browser to perform inserts. Data and constraints are validated at the time of insert, and the data is automatically saved. Sheila can also use an INSERT INTO statement to insert one record at a time into a table. A sample INSERT INTO syntax is shown in the graphic.
The VALUES clause specifies the data values to be inserted in the corresponding columns. The values must be specified in the same sequence as the column list in the INSERT INTO clause. The data type of the inserted value must match the data type for the column. Sheila must enclose date and character values in single quotation marks. Any mandatory or NOT NULL columns must be specified during inserts.
|