text: --------------------------------------------------------
  --  DDL for View SPOUSE_VIEW
  --------------------------------------------------------
  
    CREATE OR REPLACE VIEW "SPOUSE_VIEW" ("ID", "SPOUSE_ID") AS 
    SELECT P.ID ID, SPOUSE.ID SPOUSE_ID
  FROM MOTHER P, FATHER SPOUSE
  WHERE P.CHILD_ID = SPOUSE.CHILD_ID
  UNION
  SELECT P.ID ID, SPOUSE.ID SPOUSE_ID
  FROM FATHER P, MOTHER SPOUSE
  WHERE P.CHILD_ID = SPOUSE.CHILD_ID
  UNION
  SELECT M.WIFE ID, M.HUSBAND SPOUSE_ID
  FROM MARRIAGE M
  UNION
  SELECT M.HUSBAND ID, M.WIFE SPOUSE_ID
  FROM MARRIAGE M;
  