oracle中預存程序書寫規範

create or replace procedure UpdateTestData
is
j number;
dept_min_no number;
dept_max_no number;
begin
  --更新部門表
  delete from test_dept;
  for i in 1..10
    loop
      insert into test_dept(dept_name,f_deleteflag) values('部門'||i,0);
      commit;
    end loop;
  --更新使用者表
  --dept_min_no:=0;
  --dept_max_no:=0;
  select min(f_id) into dept_min_no from test_dept;
  select max(f_id) into dept_max_no from test_dept;

  delete from test_user;
  for i in 1..30
    loop
      select floor(dbms_random.value(dept_min_no,dept_max_no)) into j from dual;
      insert into test_user(f_id,username,userpwd,age,sex,birthday,telephone,address,email,memo,deptid,realname,f_deleteflag)
             values(i,'a'||i,'123456',i+20,'男',sysdate-365*i,'13500112233','北京市海澱區上地資訊大廈',j||'@163.com','備忘備忘'，j，'張三'||i，0);
    commit;
    end loop;
end UpdateTestData;