oracle 在当前库建立另一个库的连接并使用

今天想查询一条数据会用到另外一个数据库，想不切换数据库的情况下查询；

create public database link TEST_DBLINK
  connect to alibaba identified by qwer1234
  using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.111.10.5)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =orcl)
)
)'
;
DROP public DATABASE LINK TEST_DBLINK;
select * from t100_psn @TEST_DBLINK join  t_visitplansId on pid = userno where userno='44140080600004';

 

图样图森破；

你学会了吗？

 

参考：https://blog.csdn.net/xjz2000/article/details/80521591