摘要
首先简要地介绍了ORACLE数据库触发器的基本构成。然后重点阐述了如何应用数据库触发器解决几个实际问题 ,如非声明的完整性约束、自动不间断编码、特殊审计信息收集记录和视图更新等 。
In this paper, the basic structure of ORACLE database trigger was introduced. The main using of the trigger was discussed, for example, non-declared integrality constraint, automatic continually coding, information collecting and recording for special audit, view updating and etc, which are troublesome in design of database.
出处
《计算机应用研究》
CSCD
北大核心
2001年第9期136-138,共3页
Application Research of Computers
关键词
数据库
ORACLE
触发器
数据安全
Trigger
Integrality constraint
Continually coding
Audit
View updating