在Toad里面怎么把Where in绑定变量?
如:
select * from table1 where id in (1,2,3)
(1,2,3)怎么换成变量?
------解决方案--------------------
select * from table1 where id in (&1,&2,&3)
------解决方案--------------------
用占位符号 :1 :2 :3 using
select * from table1 where id in (1,2,3)
select * from table1 where id in (&1,&2,&3)