[SQL ] Oracle "In" (變數)的問題
Oracle 9i
當使用In條件式時.
VARCHAR s = "'a','b','c'";
select...from...where column in (s);
執行ok,順利找到資料.
但是如果
VARCHAR s = "a,b,c";
select...from...where column in (''' + REPLACE(s,',',''',''') + ''');
執行 找不到資料,
也就是用REPLACE把 , 取代成',' 並無法順利執行.
如果這樣無法執行,是不是寫Function或Procedure來拆字串也沒辦法?
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 60.249.204.172
→
12/14 14:17, , 1F
12/14 14:17, 1F
→
12/14 14:50, , 2F
12/14 14:50, 2F
推
12/17 11:38, , 3F
12/17 11:38, 3F
→
12/17 11:39, , 4F
12/17 11:39, 4F