17,086
社区成员
发帖
与我相关
我的任务
分享
--id为字符类型
select id,name
from test_tb1
where id in(
substr(string,1,3),
substr(string,5,3),
substr(string,9,3));
--id为数字(number)类型
select id,name
from test_tb1
where id in(
to_number(substr(string,1,3)),
to_number(substr(string,5,3)),
to_number(substr(string,9,3)));