数据库中间通讯
orccle与oracle datalink
:(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.153)(PORT = 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = oanet)))
-- Drop existing database link
drop database link TESTLINK;
-- Create database link
create database link TESTLINK
connect to GD_BASE
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.153)(PORT = 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = oanet)))';
select * from appr_auth_func@testlink
SQL SERVER:
策略与调度