数据库存储过程简单应用

将productinfo表中的数据根据不同的产品类型分类，把数据输出到屏幕
1.创建productinfo表
create table productinfo
(
product_id varchar2(64),
product_name varchar2(20),
product_price number(8,2),
quantity number(10),
category varchar2(64),
desperation varchar2(1000),
origin varchar2(10)
);
2.录入数据
– Add comments to the columns
comment on column productinfo.product_id
is ‘id’;
comment on column productinfo.product_name
is ‘商品名称’;
comment on column productinfo.product_price
is ‘商品价格’;
comment on column productinfo.quantity
is ‘商品数量’;
comment on column productinfo.category
is ‘商品分类’;
comment on column productinfo.desperation
is ‘商品描述’;
comment on column productinfo.origin
is ‘商品产地’;
– Create/Recreate primary, unique and foreign key constraints
alter table productinfo
add constraint key_product_id primary key (product_id);

insert into productinfo
(product_id,product_name,product_price,quantit