【文件属性】:
文件名称:oracle跨库查询
文件大小:550B
文件格式:SQL
更新时间:2015-06-12 05:27:45
oracle 跨库查询
oracle跨库查询
--语法
/*定义
create [public] databse link _link_name
connect to _username identified by _passowrd
using '_servername/_serverurl';
*/
/*调用
select * from _table_name@_link_name
*/
create database link link_zhangli
connect to zhangli identified by zhangli
using'
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
'
select * from street
select * from street@link_zhangli
觉得有用请给1分