您可以使用如下“标记器”函数：

select 
  id1.seq
, id1.tok as id1
, id2.tok as id2
, qty.tok as qty
from xmltable('for $id in tokenize($s, ",") return <i>{string($id)}</i>' 
passing '101,231,452,176' as "s"
columns 
  seq for ordinality
, tok int path '.'
) id1
join xmltable('for $id in tokenize($s, ",") return <i>{string($id)}</i>' 
passing '301,453,54,1265' as "s"
columns 
  seq for ordinality
, tok int path '.'
) id2 on id2.seq = id1.seq 
join xmltable('for $id in tokenize($s, ",") return <i>{string($id)}</i>' 
passing '1000,2000,7412,6521' as "s"
columns 
  seq for ordinality
, tok int path '.'
) qty on qty.seq = id1.seq;

结果是：

|SEQ                 |ID1        |ID2        |QTY        |
|--------------------|-----------|-----------|-----------|
|1                   |101        |301        |1000       |
|2                   |231        |453        |2000       |
|3                   |452        |54         |7412       |
|4                   |176        |1265       |6521       |

参数可以用来代替后面的字符串常量 passing 每个 xmltable .