Re: Creating Multiple Users

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 CDT