编程技术13 Oct 2006 10:32 am

Oracle数据库中跨库查询的连接语句

就是目前程序操作的是db1数据库,但由于某种原因,需要访问db2数据库里的表,连接如下

create database link dbLink
connect to USERID identified by PASSWORD
using ‘SID’;
/
select * from SID.tableName@dbLink;
/
drop database link dbLink;

One Response to “Oracle数据库中跨库查询的连接语句”

  1. on 18 Oct 2006 at 21:15 数据恢复

    谢谢

Trackback this Post | Feed on comments to this Post

Leave a Reply