本文介绍如何使用Oracle SQL创建一个公共数据库链接，通过指定用户名、密码和远程数据库的服务名及地址等详细信息，实现跨数据库的操作。
CREATE PUBLIC DATABASE LINK WuChang
CONNECT TO lilong IDENTIFIED BY lilong
USING '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.103.0.7)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)';
CONNECT TO lilong IDENTIFIED BY lilong
USING '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.103.0.7)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)';
扫一扫
3119
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
