110,538
社区成员
发帖
与我相关
我的任务
分享
SELECT DS_IE.CONSTR(ABBR_TRADE) INTO TRADESTRING FROM DS_IE.BDTRADE WHERE INSTR(TRADE, TRADE_MODE) > 0
CREATE OR REPLACE FUNCTION DS_IE.GETTRADE(TRADE IN VARCHAR2) --根据贸易方式数字获取贸易方式名称
RETURN VARCHAR2
IS TRADESTRING VARCHAR2(400);
BEGIN
SELECT DS_IE.CONSTR(ABBR_TRADE) INTO TRADESTRING FROM DS_IE.BDTRADE WHERE TRADE_MODE IN (TRADE);
RETURN TRADESTRING;
END;
void Main()
{
string str="123,1222,333";
str=string.Join(",",str.Split(',').Select(s=>"'"+s+"'").ToArray());
string sql=string.Format("SELECT * FROM 表 WHERE 列名 IN ({0})",str);
Console.WriteLine(sql);
//SELECT * FROM 表 WHERE 列名 IN ('123','1222','333')
}
//linq也是可以的
void Main()
{
string str="123,1222,333";
str=string.Join(",",str.Split(',').Select(s=>"'"+s+"'").ToArray());
Console.WriteLine(str);
//'123','1222','333'
}
//方法有很多 正则也可以
void Main()
{
string str="123,1222,333";
string result="";
foreach(string s in str.Split(','))
{
result+="'"+s+"',";
}
Console.WriteLine(result.Trim(','));
//'123','1222','333'
}