oracle 赋值存储过程的创建和执行

--创建存储过程

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
 student_id := 14;
 student_name := '熊敏';
 student_sex := '男';
 student_age := 25;
 student_department := 'abc';
 insert into student values(student_id,student_name,student_sex,student_age,student_department);
 commit;
end insert_student;

 

--将数据库查出来的值赋值给变量

CREATE OR REPLACE PROCEDURE XM_insert_XM_tem_table
as
 student_id number;
 student_name varchar2(255);
begin
 select ld_lastmodified into student_name from ld_history where ld_id = 1;
 insert into xm_tem_table values(student_name,1);
 commit;
end XM_insert_XM_tem_table;

--执行存储过程

exec insert_student;   --注释必须在命令行执行

--oracle数组网址

http://blog.csdn.net/giianhui/article/details/4410358