功能:查看书本价格小于v_bookprice的书名、出版社和书的价格。谢谢!
create or replace procedure query_by_price(v_bookname LEE_BOOK.BOOKNAME%type,v_bookcompany LEE_BOOK.BOOKCOMPANY%type, v_bookprice LEE_BOOK.BOOKPRICE%type)
as
begin
select BOOKNAME,BOOKCOMPANY,BOOKPRICE into v_bookname,v_company,v_bookprice from LEE_BOOK where BOOKPRICE<v_bookprice;
end;
你单独去执行下SQL就知道了
你不写in out属性,默认是in
即只是传入参数,不能做修改
只有对有OUT属性的参数才能赋值