oracle into 一次给多个变量赋值

--建表，插数据

prompt PL/SQL Developer import file
prompt Created on 2012年5月23日 by Administrator
set feedback off
set define off
prompt Creating STUDENT...
create table STUDENT
(
  STUDENTID  NUMBER not null,
  NAME       VARCHAR2(20) not null,
  SEX        CHAR(2) not null,
  AGE        NUMBER not null,
  DEPARTMENT VARCHAR2(20) not null
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
comment on column STUDENT.DEPARTMENT
  is '部门';
alter table STUDENT
  add constraint PK_STUDENT_ID primary key (STUDENTID)
  using index
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Disabling triggers for STUDENT...
alter table STUDENT disable all triggers;
prompt Truncating STUDENT...
truncate table STUDENT;
prompt Loading STUDENT...
insert into STUDENT (STUDENTID, NAME, SEX, AGE, DEPARTMENT)
values (1, '熊敏', '男', 24, '学习部');
insert into STUDENT (STUDENTID, NAME, SEX, AGE, DEPARTMENT)
values (2, '熊伟', '男', 23, '技术部');
insert into STUDENT (STUDENTID, NAME, SEX, AGE, DEPARTMENT)
values (3, '熊无名', '男', 19, '学习部');
insert into STUDENT (STUDENTID, NAME, SEX, AGE, DEPARTMENT)
values (5, '杨茹', '女', 19, '生活部');
insert into STUDENT (STUDENTID, NAME, SEX, AGE, DEPARTMENT)
values (4, '黄维', '女', 22, '生活部');
insert into STUDENT (STUDENTID, NAME, SEX, AGE, DEPARTMENT)
values (12, '熊敏', '男', 25, 'abc');
insert into STUDENT (STUDENTID, NAME, SEX, AGE, DEPARTMENT)
values (13, '熊敏', '男', 25, 'abc');
insert into STUDENT (STUDENTID, NAME, SEX, AGE, DEPARTMENT)
values (14, '熊敏', '男', 25, 'abc');
insert into STUDENT (STUDENTID, NAME, SEX, AGE, DEPARTMENT)
values (7, '林文伟', '男', 23, '学习部');
insert into STUDENT (STUDENTID, NAME, SEX, AGE, DEPARTMENT)
values (8, '王正国', '男', 23, '学习部');
insert into STUDENT (STUDENTID, NAME, SEX, AGE, DEPARTMENT)
values (9, '王正国', '男', 23, '学习部');
insert into STUDENT (STUDENTID, NAME, SEX, AGE, DEPARTMENT)
values (10, '黄广', '男', 23, '学习部');
insert into STUDENT (STUDENTID, NAME, SEX, AGE, DEPARTMENT)
values (11, '黄云生', '男', 23, '学习部');
insert into STUDENT (STUDENTID, NAME, SEX, AGE, DEPARTMENT)
values (6, '龙寒', '男', 23, '学习部');
commit;
prompt 14 records loaded
prompt Enabling triggers for STUDENT...
alter table STUDENT enable all triggers;
set feedback on
set define on
prompt Done.

 

--存储过程

CREATE OR REPLACE PROCEDURE insert_student
as
 student_id number;
 student_name varchar2(20);
 student_sex varchar2(20);
 student_age number;
 student_department varchar2(20);
begin
 select name,sex into student_name,student_sex from student where studentid = 1;
 db
end insert_student;