Re: Creating Multiple Users
From: John D Groenveld <groenvel_at_cse.psu.edu>
Date: 1998/04/23
Message-ID: <6hoa9f$7ns$1_at_tholian.cse.psu.edu>#1/1
Date: 1998/04/23
Message-ID: <6hoa9f$7ns$1_at_tholian.cse.psu.edu>#1/1
CREATE TABLE class_list (userid VARCHAR(6),ssn NUMBER(9)); INSERT INTO class_list VALUES ('baw128',123456789); SELECT 'create user ' || userid || ' indentified by ' || ssn || ';' FROM class_list
spool it to file and run it as a sqlplus script.
If you're not stuck with sqlplus, I'd use Perl with DBI
John
jdg117_at_psu.edu
Received on Thu Apr 23 1998 - 00:00:00 CEST