powerdesigner生成的sql檔案匯入oracle產生Warning: Trigger created with compilation errors，然后在表中插入資料時會有觸發器無效或未通過驗證，這是什么原因？
uj5u.com熱心網友回復：
create or replace trigger D_m_account_datafor delete on M_ACCOUNT_DATA compound trigger
// Declaration
// Body
before statement is
begin
NULL;
end before statement;
before each row is
begin
NULL;
end before each row;
after each row is
begin
NULL;
end after each row;
after statement is
begin
NULL;
end after statement;
END
/
create or replace trigger I_m_account_data
for insert on M_ACCOUNT_DATA compound trigger
// Declaration
// Body
before statement is
begin
NULL;
end before statement;
before each row is
begin
NULL;
end before each row;
after each row is
begin
NULL;
end after each row;
after statement is
begin
NULL;
end after statement;
END
/
create or replace trigger U_m_account_data
for update on M_ACCOUNT_DATA compound trigger
// Declaration
// Body
before statement is
begin
NULL;
end before statement;
before each row is
begin
NULL;
end before each row;
after each row is
begin
NULL;
end after each row;
after statement is
begin
NULL;
end after statement;
END
/
這個是出例外的sql代碼
uj5u.com熱心網友回復：
// 你這個符號是注釋嗎？oracle的注釋有單行注釋----，多行注釋 /* */轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/93574.html
標籤：開發
上一篇：存盤程序編碼找出物料編碼為“1”或“5”開頭的物料對應的成本物件/產品為“8”或字母開頭的成品關系；一共需出具2014-2017年4年對應清單