------------ Creat dblink ------------------------
CREATE DATABASE LINK "LCMDB" CONNECT TO "LCM"
IDENTIFIED BY "lcm"
USING 'LCM_DB'
/
------------------------------------
CREATE OR REPLACE TRIGGER "DELETE_GROUPS" AFTER
DELETE ON "GROUPS" FOR EACH ROW
begin
enqueue_packet('update_queue', 'delete', 'groups' || ',' || :old.groupname);
---------------------------------------------------------------------
delete from lcm.memberbank a where a.group_name=:old.groupname;
end;
/
总是出现编译出错,来找大家帮帮忙
CREATE DATABASE LINK "LCMDB" CONNECT TO "LCM"
IDENTIFIED BY "lcm"
USING 'LCM_DB'
/
------------------------------------
CREATE OR REPLACE TRIGGER "DELETE_GROUPS" AFTER
DELETE ON "GROUPS" FOR EACH ROW
begin
enqueue_packet('update_queue', 'delete', 'groups' || ',' || :old.groupname);
---------------------------------------------------------------------
delete from lcm.memberbank a where a.group_name=:old.groupname;
end;
/
总是出现编译出错,来找大家帮帮忙
解决方案 »
- oracle 11g 怎样导入 10G的备份文件呀
- 请问新建一个表时,有一个“方案”下拉供我选择,这是什么意思,,感谢
- 请帮忙将sqlserver上的SQL语句转换成oracle的标准语句
- 请教关于存储过程的标号处理问题
- TNS:无法处理服务名,都可能存在哪些问题?
- 存储过程中的游标问题
- (100分求)数据库从9i到9i2升级后一直显示ORA-01033:ORACLE initialization or shutdown in progress
- 请教,用oracle一句sql文完成下面功能
- ORCALE下操作BLOB一问 (vc)
- 有谁可以告诉我为什么进不了Oracle Enterprise Manager,OracleOraHome81ManagementServer服务启动不了是什么回事?加急!!!!
- 请教sql
- 请大家过来看看,up有分!!
delete from memberbank@lcm a where a.group_name=:old.groupname;