Here's a specific question that I have about Oracle SQL. I have a
table that is aggregated by a column called "store_id". Each store_id
has several rows associated with it. The store_id '999' represents the
"template" store. Whenever I add a new store, I copy all the template
rows out and then insert them back in with the new id. After copying
the rows from the template, I customize them per the store owner's
requests. (That's why I need to be able to do this.) Right now the way
I do it is by using a program that performs a SELECT and pulls all the
rows, changes the STORE_ID, then issues several INSERT queries to put
the rows into the table for that new store. But I don't like having to
transfer the data with an external program, because it is getting hard
to maintain this solution and keep it portable. Is there a way to
perform this operation with using only SQL? Just point me in the right
direction. Thanks!
Received on Tue Feb 10 2004 - 11:00:37 CST
