我想通过传入参数筛选数据
insert into xxx (select * from aaa where xxxx like '''||参数变量||'%'||''')
效果如select * from aaa where xxx like '传入变量值%'应该如何写呢????
insert into xxx (select * from aaa where xxxx like '''||参数变量||'%'||''')
效果如select * from aaa where xxx like '传入变量值%'应该如何写呢????
insert into xxx select * from aaa where xxxx like 参数变量||'%'
如果表xxx或者字段xxxx都是通过参数传入的,那么就需要用动态SQL了。