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, ...
0xweathered.hashnode.dev1 min read