PL/SQL question re inserts

Not sure if this is the correct forum for this question, but here goes.

I want create a new row in a table which is identical to an existing row except for the key value.

Is there an easy way to do this using the Insert statement, rather than reading and storeing the original record and then specifying each value for the insert statement?

JL Received on Wed Aug 27 2003 - 06:42:37 CDT