PL/SQL常用脚本（待续）

create table student(stdid varchar2(20), stdname varchar2(20), stdscore number)
commit;
select * from student


--修改表结构
alter table student add(stdmajor varchar2(20));


--循环方式1
declare 
 v_loopcounter  BINARY_INTEGER :=1;
begin
  loop
    insert into student(stdscore) values(v_loopcounter);
    v_loopcounter := v_loopcounter + 1;
    exit when v_loopcounter > 50;
  end loop;
end;






--循环方式2
begin
  for v_loopcounter in 100..150 loop
    insert into student(stdscore) values(v_loopcounter);
  end loop;
end;


--游标


declare 
  v_score varchar(20);
  cursor c_Students IS
    select stdscore from student;
begin
  open c_Students;
  loop 
    fetch c_Students into v_score;
    dbms_output.put_line(v_score);
    exit when c_Students%NOTFOUND;
  end loop;
end;