Schema Compare creates a blank line in scripts with union all. The spaces in the script are treated like separators and it runs as separate commands instead of creating a view based off a union.
Ex:
Prompt View STRAT_VW;
CREATE OR REPLACE FORCE VIEW HIEU.STRAT_VW
(COLUMN1)
AS
SELECT z.a_key
FROM
a_tbl z
UNION ALL
SELECT x.b_key
FROM
b_tbl x
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center