初始化数据ＳＱＬ

BEGIN
  FOR I IN (select did from sys_departmentinfo where name = '办公室')
  LOOP
    insert into sys_usermaininfo
    values
      (seq_sys_usermaininfo.nextval,
       'qhsss2',
       '96e79218965eb72c92a549dd5a330112',
       to_date('2011-02-18', 'yyyy-mm-dd'),  1,1, 2,1, I.did, '否');
  END LOOP;
  FOR II IN (select umid from sys_usermaininfo where loginid ='qhsss')
  LOOP
   insert into sys_userbasicinfo values(seq_sys_userbasicinfo.nextval,
   'sswewe','qhs','1', '', '','', '','',II.umid, '');
  END LOOP;
END;

loader.ctl 文件

load data
infile *
append into table test
fields terminated by " "
(dep,
post
)
begindata
领导班子 局长经理书记
领导班子 副经理
领导班子 正处调研员
领导班子 副局长
领导班子 副经理
领导班子 纪委书记工会主
领导班子 副经理

cmd f:\sqlldr name/pwd@orcl control=loader.ctl