The
JDBC forum would be a more appropriate place for this question, but I'll give it a shot.
There is no single SQL statement that will delete a row from one table and insert it into another. However, if your database supports transactions, you can use a transaction to contain both the insert and delete statement. By doing so, the two statements are treated as an atomic operation where both statements succeed, or neither takes effect.
hth,
bear