Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## INSERT

> Inserts new rows into the specified table or view that will contain either the explicitly specified values or the values returned by the query expression.

> #### Syntax

>     INSERT INTO [ owner_name.]{table_name|view_name }
>       [ ( column_name [, column_name ] , ... ) ]
>       { VALUES ( value [, value ] , ... ) | query_expression } ;

> Examples

>     INSERT INTO customer (cust_no, name, street, city, state)
>          VALUES
>              (1001, 'RALPH', '#10 Columbia Street', 'New York', 'NY') ;

>     INSERT INTO neworders (order_no, product, qty)
>          SELECT order_no, product, qty
>               FROM orders
>               WHERE order_date = SYSDATE ;

> #### Notes

> - If the optional list of column names is specified, then only the values for those columns are required. The rest of the columns of the inserted row will contain `NULL` values, provided that the table definition allows `NULL` values and there is no `DEFAULT` clause for the columns. If a `DEFAULT` clause is specified for a column and the column name is not present in the optional column list, then the column is given the default value.

> - If the optional list is not specified, then all the column values must be either explicitly specified or returned by the query expression. The order of the values should be the same as the order in which the columns are declared in the declaration of the table or view.

> - The `VALUES` ( ... ) form for specifying the column values inserts one row into the table. The query expression form inserts all the rows from the query results.

> - If the table contains a foreign key and there is no corresponding primary key that matches the values of the foreign key in the record being inserted, the insert operation is rejected.

> ##### Authorization

> Must have `DBA` privilege, ownership of the table, `INSERT` privilege on the table, or `SELECT` privilege on all the tables or views referred to in the query_expression, if a query_expression is specified.

> ##### Related statements

> REVOKE

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095