Re: How can I copy rows into same table?

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!

INSERT INTO mytable
(col1, col2, col3, col4)
SELECT 'newvalue', col2, col3, col4
FROM mytable
WHERE ...

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)