BEGIN
EXECUTE IMMEDIATE 'CREATE OR REPLACE VIEW VSTRUCTDIVISIONPARENTSANDTHIS
    AS
    SELECT  ID AS ID, ID AS PARENTID FROM STRUCTDIVISION
    UNION 
    SELECT  ID AS ID, PARENTID AS PARENTID FROM VSTRUCTDIVISIONPARENTS';
END;