-
编辑 删除
Trigger3-Insert Row Trigger Syntax
The Insert Row trigger has the following syntax.CREATE OR REPLACE TRIGGER trigger_nameAFTER|BEFORE INSERT ON table_nameFOR EACH ROW[WHEN (Boolean expression)]DECLARE Local declarationsBEGIN ...
-
编辑 删除
Trigger Introduction
IntroductionA trigger is a compiled procedure stored in the database. The language you use is PL/SQL. You code and compile a trigger in the same manner you code stored procedures. The following is the...
-
编辑 删除
Trigger Body
The trigger body is written in PL/SQL. There are PL/SQL expressions that only have meaning within a trigger body. These topics are covered in the following paragraphs.A trigger body can refer to two s...
-
编辑 删除
Trigger 2-Before versus After
The insert of a single row has three stages. Figure 6-1 illustrates each stage. There are two stages in which you can inject your PL/SQL code. The middle stage is the Oracle constraint enforcement. Th...
