建表:
create table stu_kr(
stu_id varchar2(10),
sname varchar2(20),
Sage date,
Ssex varchar2(10)
)
存储过程:
create or replace procedure insert_stu_kr(cid varchar2,
cname varchar2,
cage varchar2,
csex varchar2 )
is
begin
insert into stu_kr
(stu_id, sname,sage,ssex)
values
(cid,
cname,
to_date(cage, 'yyyy-MM-dd'),
csex
);
commit;
end insert_stu_kr;