# sql | duplicating a resultset

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.
```