模糊查询
select a.APPLE,a.ORANGE,a.BANANA from fruit a left join shop b on a.APPLE=b.APPLE where 1=1
a.APPLE like ‘%’ ||#Apple#||’%’
动态sql
insert into fruit(APPLE
BANANA
ORANGE
)
values(#Apple#
#Banana#
#Orange#
)