Oracle 查找未用 编码
<br />Select Min(N.编码) As Max_编码<br />From (<br /> Select Min(M.比较码) As 编码, 'N' As 类别<br /> From (<br /> Select Lpad(Level, 2, '0') As 比较码<br /> From dual<br /> Connect By Level <= (Select Max(A.编码) From 用
原创
2010-10-26 11:02:00 ·
420 阅读 ·
0 评论