在数据库mydb1中:
create database link link_name
connect to username identified by password <----这里是mydb2的登陆名和密码
using '联结串' <---这里是到mydb2的连接串然后在mydb1中:
select * from mytable1 a,mytable2@link_name b where a.mydate=b.mydate and a.myno=b.myno
create database link link_name
connect to username identified by password <----这里是mydb2的登陆名和密码
using '联结串' <---这里是到mydb2的连接串然后在mydb1中:
select * from mytable1 a,mytable2@link_name b where a.mydate=b.mydate and a.myno=b.myno
create database link linkname
connect to 用户名 identified by 密码
using '数据库服务名';
然后 select * from tab@linkname