The INSERT statement is used to insert values into a single database table.
<insert statement> ::= INSERT INTO <table name> <insert column list> <insert source>. |
In Open SQL the <insert column list> is not optional.
You cannot specify string literals as values for CLOB columns. Hex literals, date literals, time literals and timestamp literals are not supported in Open SQL.
INSERT INTO employees (employee_id, employee_name)
|
Inserting Values. A new row is inserted into the table employees with the values 4711 and 'John Smith' for the columns employee_id and employee_name respectively.
INSERT INTO well_paid_employees (employee_id,
salary) |
Inserting the Result of a Query. The employee_id and the salary of all employees from table employees with a salary exceeding a certain value are inserted into the table well_paid_employees.
More information: