显示商品的信息,双11打折规则:
–(1)电子产品打8折,食品7折
–(2)不能低于成本价,低于成本价,以成本价销售
题目描述:
plsql编程显示商品表信息:
declare
cursor p is select * from product;
v_name PRODUCT.NAME%type;
v_type PRODUCT.TYPE%type;
v_cost PRODUCT.COST%type;
v_retail PRODUCT.RETAIL%type;
begin
open p;
fetch p into v_name,v_type,v_cost,v_retail;
whil