WITH base_new
AS (SELECT -- TODO select column list
FROM table_with_new_data
WHERE -- TODO adapt where clause
)
, base_old
AS (SELECT -- TODO copy column list from new data table
FROM table_with_old_data
WHERE -- TODO copy where clause from new data table
)
, new
AS (SELECT 'new' AS src, t.*
FROM base_new t
MINUS
SELECT 'new' AS src, t.*
FROM base_old t)
, old
AS (SELECT 'old' AS src, t.*
FROM base_old t
MINUS
SELECT 'old' AS src, t.*
FROM base_new t)
, uni
AS (SELECT * FROM old
UNION ALL
SELECT * FROM new)
SELECT /*+ parallel(4) */
*
FROM uni
ORDER BY 2 ASC, 3 ASC, 1 ASC;
Dienstag, 3. Mai 2016
Quick regression test statement
Abonnieren
Posts (Atom)