Bricklen wrote:
> Andrew Strader wrote:
>
>> 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!
>
> what version of oracle and os?
> are you trying to do this in sql*plus only, or use a specific tool?
> net8? odbc?
>
> more details for an acceptable answer are needed.
Oops, appeared to have missed the title of your email!
describe the structure of your table: you have a primary key etc
Received on Tue Feb 10 2004 - 11:13:25 CST
