首先新建一个表:
create table shopinfo(
shopperson varchar(10),
product varchar(10),
shopnum integer
)
插入多条数据:
insert all
into shopinfo values('A','甲',2)
into shopinfo values('B','乙',4)
into shopinfo values('C','丙',1)
into shopinfo values('A','丁',2)
into shopinfo values('B','丙',5)
select 1 from dual;
查询这个表:
select * from shopinfo
结果如下: