利用powerdesigner建模，因為同一功能模塊的表的前半部分命名相同，powerdesigner生成的觸發器名稱又加了一些前綴資訊，導致觸發器出現重名，這個需要怎么修改？
uj5u.com熱心網友回復：
如：create or replace trigger CompoundDeleteTrigger_m_electr
for delete on M_ELECTRIC_MAINTENANCE_HISTORY 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 CompoundDeleteTrigger_m_electr
for delete on M_ELECTRIC_ITEM 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
/
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/93572.html
標籤：基礎和管理
上一篇：創建一個觸發器，使得每增加一個回帖，就在對應的主題帖總修改回復數+1
下一篇：存盤程序編碼找出物料編碼為“1”或“5”開頭的物料對應的成本物件/產品為“8”或字母開頭的成品關系；一共需出具2014-2017年4年對應清單