ebs 新老系统切换消息导入脚本

最新推荐文章于 2024-11-24 18:32:40 发布

原创最新推荐文章于 2024-11-24 18:32:40 发布 · 629 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#database #insert #delete #service #脚本 #list

EBS 专栏收录该内容

14 篇文章

订阅专栏

本文提供了一系列Oracle数据库的操作示例，包括创建数据库链接、跨数据库查询、数据同步及更新等实用技巧，适用于需要进行复杂数据管理与迁移的应用场景。

CREATE DATABASE LINK xxx_link
CONNECT TO APPS IDENTIFIED BY APPS
USING '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1522)))(CONNECT_DATA =(SERVICE_NAME = xxx)))';

SELECT *
FROM fnd_new_messages fnm
WHERE fnm.application_id = 20044;

DELETE FROM fnd_new_messages fnm WHERE fnm.application_id = 20008;

INSERT INTO fnd_new_messages
SELECT * FROM fnd_new_messages@xxx_link fnm
WHERE fnm.application_id = 20008
AND fnm.message_name IN ('XXxxx_016_W014','XXxxx_016_W015','XXxxx_016_W016');

UPDATE fnd_new_messages fnm
SET fnm.application_id = 20044
WHERE fnm.application_id = 20008;

DROP DATABASE LINK xxx_link;