begin
--创建数据库连接
-- 连接名
CREATE PUBLIC DATABASE LINK database_link_name
-- 要连接数据库登录名
CONNECT TO dbusername
-- 要连接数据库登录密码
IDENTIFIED BY dbuserpwd -- 要连接数据库登录密码
USING '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.20.129.81)(PORT=1531)))(CONNECT_DATA=(SERVICE_NAME=db_servicename)))';
SELECT * FROM local_db_username.tablename1 lt
UNION
SELECT * FROM reomote_tablename@database_link_name rt
WHERE lt.sort_id != rt.sort_id and lt.suite_name != rt.suite_name and lt.tran_code != rt.tran_code ;
DROP PUBLIC DATABASE LINK database_link_name ;
end;
oracle数据库连接用于垮库查询
最新推荐文章于 2024-04-23 15:41:12 发布