一、oracle数据库连接oracle
CREATE DATABASE LINK "linkname"
CONNECT TO "username" IDENTIFIED BY "password"
USING '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)';
其中 :
linkname为数据库连接的名字,按需求自定义
username为要连接数据库的用户名
password为要连接数据库的密码
ip 要连接数据库地址
二、查询SQL
select * from tablename@linkname