create or replace procedure printrequired (p_Department in class_material.department%type) is
v_books class_material.required _reading%type;
begin
select required_reading
into v_books
from class_material
where department=p_Department;
这里的p_Department 不是还没设定???只是设定了类型?怎么下面就用到了department=p_Department。。不懂。。请帮忙解释下~
v_books class_material.required _reading%type;
begin
select required_reading
into v_books
from class_material
where department=p_Department;
这里的p_Department 不是还没设定???只是设定了类型?怎么下面就用到了department=p_Department。。不懂。。请帮忙解释下~
printrequired ('10');
end;
/
看你问了好几个这样基础的问题
说明你根本就啥都不懂
p_Department 是定义的参数名
in代表是传入参数
class_material.department%type 定义参数的类型:与class_material表的department字段类型一致
因为后面要把department字段的值赋给这个参数
你看看pl/sql的存储过程,里面有详细描述