创建删除存储过程
procedure create_student(
p_id varcahr2,
p_name varchar2
)is
begin
insert into student_test(id,name) values(p_id,p_name);
end create_student;
创建删除序列
-- Create sequence
create sequence ITF_STUDENT_TEST_S
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;
drop sequence ITF_STUDENT_TEST_S;