在Oracle中,可以使用如下的SQL语句来生成包含1000行数据的dual表:
SELECT * FROM (
SELECT LEVEL AS id FROM DUAL CONNECT BY LEVEL <= 1000
) WHERE ROWNUM <= 1000;
在Oracle中,可以使用如下的SQL语句来生成包含1000行数据的dual表:
SELECT * FROM (
SELECT LEVEL AS id FROM DUAL CONNECT BY LEVEL <= 1000
) WHERE ROWNUM <= 1000;