Powerdesigner generates SQL file import oracle Warning: Trigger created with compilation errors, and then insert the data in the table when the Trigger is invalid or not through the verification, what reason is this?

CodePudding user response:

The create or replace the trigger D_m_account_data
For the delete on M_ACCOUNT_DATA 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



The create or replace the trigger I_m_account_data
For the insert on M_ACCOUNT_DATA 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



The create or replace the trigger U_m_account_data
For update on M_ACCOUNT_DATA 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

This is an unusual SQL code

CodePudding user response:

This symbol is a comment//you? Oracle's comments have single-line comments -, multiline comment/* */