copying a record within a table

I would like to make a copy of a record and only change the primary key. I do not want to list every column, because if the table changes, then I will have to modify my stored proc. For example, I do not want to do the following: insert into customer
select sq_cust.nextval, name, first_name from customer
where customer_nbr = 12;

I would like to use this in a Stored Proc.

Thanks in advance
Mark

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue May 09 2000 - 00:00:00 CDT