Use of powerdesigner modeling, because the same function module table named after the first half of the same, powerdesigner generate a trigger name prefix added some information, lead to trigger a moniker, the need to modify?

CodePudding user response:

Such as:
The create or replace the trigger CompoundDeleteTrigger_m_electr
For the delete on M_ELECTRIC_MAINTENANCE_HISTORY compound trigger
//Declaration
//Body
Before the statement is
The begin
NULL;
End before the statement;

Before each row is
The begin
NULL;
End before each row;

After each row is
The begin
NULL;
End after each row;

After the statement is
The begin
NULL;
End after the statement;

END

And
The create or replace the trigger CompoundDeleteTrigger_m_electr
For the delete on M_ELECTRIC_ITEM compound trigger
//Declaration
//Body
Before the statement is
The begin
NULL;
End before the statement;

Before each row is
The begin
NULL;
End before each row;

After each row is
The begin
NULL;
End after each row;

After the statement is
The begin
NULL;
End after the statement;

END
/