日期:2014-05-17 浏览次数:20743 次
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;