insert into multiple tables using select in stored procedure
688463Nov 23 2009 — edited Jul 11 2012I am using oracle 10g R2. I want to insert records into two tables by using select query (insert into tablename select ...) in a stored procedure. How can i insert records into two table at same time using one select statement?
My second question is also related to first one... can i use clustering mechanism here because both tables are based on same structure and data? One contains 24hrs data and one has 10 days records.
Thanks.