create procedure insert_pm
(
@prj_id varchar(20), @prj_name varchar(50),
@emp_id varchar(20), @emp_name varchar(20),
@sal_type varchar(2), @salary float
)
begin
insert into project values(@prj_id, @prj_name);
insert into employee values(@emp_id, @emp_name);
insert into salary values(@sal_type, @salary)
end;
(
@prj_id varchar(20), @prj_name varchar(50),
@emp_id varchar(20), @emp_name varchar(20),
@sal_type varchar(2), @salary float
)
begin
insert into project values(@prj_id, @prj_name);
insert into employee values(@emp_id, @emp_name);
insert into salary values(@sal_type, @salary)
end;
去掉这个好象就是对的饿了
prj_name nvarchar2(50);
emp_id nvarchar2(20);
emp_name nvarchar2(20);
sal_type nvarchar2(2);
salary NUMBER(6, 2); -- 6为这个数字长度,2为小数为数begin insert into project values (prj_id, prj_name);
insert into employee values (emp_id, emp_name);
insert into salary values (sal_type, salary);
end insert_pm;