Let me see if I can explain it better today. :-) I have about 200 users in "district 1". I need to add each of those users into "district 2" using the same information that they have in "district 1". I also need to make sure they are only inserted 1 time. They have a unique employeeID, so I know I can use that to make sure that they are inserted 1 time.
"Ron Reidy" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] What do you mean by 'insert that user into a new district'? Do you mean create an oracle account? -- Ron Reidt Lead DBA Array BioPharma, Inc. -----Original Message----- From: Robert [mailto:[EMAIL PROTECTED] Sent: Thu 2/10/2005 11:26 AM To: [email protected] Cc: Subject: finding and inserting 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 This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
