如何按照表中某一数值型字段,将该条数据拆分成该数值所指定行数的数据?

2025-05-19 14:20:41
推荐回答(1个)
回答1:

select DISPATCH_ID,OUTPROOF_BATCH_KEY,ITEM_KEY,ITEM_LOTID,QTY from table connect by rownum<=QTY