finding and inserting

From: Robert (catcher_at_linuxmail.org)
Date: 02/10/05 

To: dbi-users@perl.org
Date: Thu, 10 Feb 2005 13:26:18 -0500

I am not sure how to go about this.

I have an Oracle database with users in a district. Every time I have to add
a new district I have to reset the password. I thought, now why don't I use
Perl to just copy the users current info and insert that into the new
district with the name of the district changing.

What I need to do is loop through the database and find a user, insert that
user into the new district, find next user, make sure that user is not
already in the new district to prevent duplicates, insert user into new
district changing the district information. There will be exceptions but I
think I can handle those if I can get started on the first part.

My Perl and DBI skills are not quite up to this...so help would be
appreciated.

Robert