Kbase P30744: How do I insert into a database from SQL-92?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/12/2008 |
|
Status: Verified
GOAL:
How do I insert into a database from SQL-92?
GOAL:
Are there sample statement for insert into SQL statement?
GOAL:
What are sample statement for insert into?
GOAL:
What is syntax for insert into SQL statement?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
Syntax:
INSERT INTO [ owner_name.]{table_name|view_name }
[ ( column_name [, column_name ] , ... ) ]
{ VALUES ( value [, value ] , ... ) | query_expression } ;
Sample 1:
INSERT INTO customer (cust_no, name, street, city, state)
VALUES (1001, 'RALPH', '#10 Columbia Street', 'New York', 'NY') ;
Sample 2:
INSERT INTO neworders (order_no, product, qty)
SELECT order_no, product, qty
FROM orders
WHERE order_date = SYSDATE ;