生成SQL记录集的一些数据
摘要:生成1-100的数字:select rownum from dual connect by rownum<=100生成10-100的数字:select rownum+(10-1) from dual connect by rownum<=100-(10-1)生成100以内的基数:select rownum*2-1 from dual connect by rownum<=50生成...
阅读全文
posted @ 2007-08-18 23:31