单条sql语句中跨库查询案例

SELECT * FROM ALL_DB_LINKS; – 这句语句是查询所有的连接

– 下面的语句是新建一个别的库的连接
CREATE PUBLIC DATABASE LINK 连接名称 CONNECT TO 登录名 IDENTIFIED BY 密码 USING ‘(
DESCRIPTION = (
ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 端口号))
)
(CONNECT_DATA = (SERVICE_NAME = 数据库名))
)’;
DROP PUBLIC DATABASE LINK A720; – 删除某个连接
例如：
CREATE PUBLIC DATABASE LINK A12 CONNECT TO jta12dwasss IDENTIFIED BY jtqwecwr1357 USING ‘(
DESCRIPTION = (
ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 13.08.97.121)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = ACPDBS))
)’;

select * from rtoc_rtd_quality_p_monitor@A7; --跨库查询实例（rtoc_rtd_quality_p_monitor 在本库中没有这个表，而是A7（自己建的连接名）的表）