我传一个字符参数a过来 a:=1,2,3但是执行select id from table where a in (a);
时候报ORA-01722: invalid number。我在想有没有xxx(a)方法
select xxx(a) as a from dual
a
1
2
3
那么我select id from table where a in (select xxx(a) as a from dual);
就可以运行了
时候报ORA-01722: invalid number。我在想有没有xxx(a)方法
select xxx(a) as a from dual
a
1
2
3
那么我select id from table where a in (select xxx(a) as a from dual);
就可以运行了
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货