Progress
SQL-92
Guide and Reference


INSERT Statement

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

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.

SQL COMPLIANCE

SQL-92, ODBC Core SQL grammar

ENVIRONMENT

Embedded SQL, interactive SQL, ODBC applications, JDBC applications

RELATED STATEMENTS

"Query Expressions" in "SQL-92 Language Elements"


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