![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif)
Code
CREATE PUBLIC DATABASE LINK 数据链名称 CONNECT TO 登陆用户名 IDENTIFIED BY 密码 USING '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 对方Oracle服务器的IP地址)(PORT = 端口号))
)
(CONNECT_DATA =
(SERVICE_NAME = 对方Oracle服务器服务名)
)
)'
drop PUBLIC DATABASE LINK conjcdsda4
SELECT 字段名 FROM TableName@数据链名称;