Skip to main content

Command Palette

Search for a command to run...

sql | duplicating a resultset

Updated
1 min readView as Markdown

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.
35 views

More from this blog

garbagedump

13 posts

issues I face at the workplace I love-hate & then forget about, just to face them again. solely for personal ref, please be cautious :) know a better solution? help me learn :D 0xweathered@gmail.com