Insert Statement Examples

Example 1

INSERT INTO products (product_id, description, price, currency)
                         VALUES ('139, 'PRODUCT_139', 5000, 'USD');

Example 2

INSERT INTO sales (id, amount, customer_id)
                   SELECT id, amount, customer_id
                       FROM offers
                    WHERE sold = 'YES'
                       AND date > '01-AUG-2011' ;