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分