posted 21 years ago
NO man if you can do this if you are using Oracle 9i, this is the best feature Oracle 9i provides
INSERT ALL
INTO
sales (prod_id, cust_id, time_id, amount) VALUES (product_id,
customer_id, weekly_start_date, sales_sun) INTO sales (prod_id, cust_id,
time_id, amount) VALUES (product_id, customer_id, weekly_start_date+1,
sales_mon)
INTO sales (prod_id, cust_id, time_id, amount) VALUES (product_id,
customer_id, weekly_start_date+2, sales_tue)
INTO sales (prod_id, cust_id, time_id, amount) VALUES (product_id,
customer_id, weekly_start_date+3, sales_wed)
INTO sales (prod_id, cust_id, time_id, amount) VALUES (product_id,
customer_id, weekly_start_date+4, sales_thu)
INTO sales (prod_id, cust_id, time_id, amount) VALUES (product_id,
customer_id, weekly_start_date+5, sales_fri)