garbagedump

sql | duplicating a resultset

weathered's photo
weathered
·

1 min read

there has to be an easier way other then CTRL+C CTRL+V, right?

CARTESIAN QUERY

SELECT  X.*
  FROM  (
            'INSERT SELECT STATEMENT HERE'
        ) X, (SELECT 1 FROM DUAL CONNECT BY LEVEL <= 'NO OF REPLICATIONS');

example:

SELECT T.TABLE_NAME, T.DATA_LENGTH, T.LAST_ANALYZED
  FROM ALL_TAB_COLS T
 FETCH FIRST 10 ROWS ONLY;

10 rows selected.
-------------------------
SELECT X.*
  FROM (SELECT T.TABLE_NAME, T.DATA_LENGTH, T.LAST_ANALYZED
          FROM ALL_TAB_COLS T
         FETCH FIRST 10 ROWS ONLY
        ) X, (SELECT 1 FROM DUAL CONNECT BY LEVEL <= 40);

400 rows selected.
SQLOracle