Views created by UNION ALL could be updated with both UPDATE and
DELETE operations. They are just transformed to UPDATE/DELETE
operation on base tables (or views). I think INSERT cannot be accepted
however. For example, suppose we have v1:
CREATE VIEW v1 AS SELECT * FROM t1 UNION ALL SELECT * FROM t2;
Inserting into v1 is ambiguous because it can be transformed either
inserting into t1 or t2.
So I think we could make v1 auto updatable view.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp