Oracle Tutorial

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' ;