Oracle中基于多表的可更新视图的实现与应用

Realization and Application of Updatable Views based on Multiple Tables in Oracle

Oracle数据库中通过对可更新视图进行数据的插入、修改和删除操作,可以将数据库应用系统中复杂的数据逻辑封装在数据层内,使应用逻辑得以简化。本文在介绍了视图和触发器使用方法的基础上,通过应用实例探讨了多表联合的可更新视图的实现方法和实际意义。

In Oracle database, data can be insert?modify and delete thr ough updatable views,so that complicated logic of data are encapsulated in data layer, and applied lo gic can become easy. The using method of views and triggers is introduced in this article. The method of realizing updatable views based on multiply tables and its realistic meaning are also discussed in this article by using applied instances.