不懂oracle,楼主解释for update nowait是什么意思?
--sql中没有rowid,可以用临时表加标识字段来完成SELECT REVISION, S_ROWID=identity(int,1,1)
FROM TEST1
WHERE SHOHINID = @SHOHINID
AND KUBUN = @KUBUN
--sql中没有rowid,可以用临时表加标识字段来完成SELECT REVISION, S_ROWID=identity(int,1,1)
FROM TEST1
WHERE SHOHINID = @SHOHINID
AND KUBUN = @KUBUN
INTO NewTable
FROM OldTable不过还是把分结了。