利用powerdesigner建模,因为同一功能模块的表的前半部分命名相同,powerdesigner生成的触发器名称又加了一些前缀信息,导致触发器出现重名,这个需要怎么修改?
解决方案 »
- exp问题
- 用什么sql可以快速的看出三张表主外键之间的关系呢?要查看那张表
- 如何编写oracle的存储过程、函数?并在java jsp页面中调用?java 调用oracle function出错!!
- 请教两个select count(1) SQL 查询出结果不一致
- jdbc选程连接oracle出现Io 异常: The Network Adapter could not establish the connection!
- 高手请进关于Oracle监听问题
- 求助:关于服务!
- win98启动瘫痪,ORACLE7如何备份
- 一个包的简单问题,请大家帮我看看
- 如何在一个PL/SQL存储过程中输出一个数据集?
- 创建一个触发器,使得每增加一个回帖,就在对应的主题帖总修改回复数+1
- powerdesigner生成的sql文件导入oracle产生Warning: Trigger created with compilation errors
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
/