Hmm, Norman, I don't think that's because Raj asks how to do it with PL/SQL that I would feel compelled to do it with PL/SQL ... An INSERT ... SELECT can do it as well, and much faster ... I know what you are going to say about committing, but it would allow you to do it in direct mode ... HTH S Faroult -- //www.freelists.org/webpage/oracle-l