方法如下： 第一、创建远程链接的link： create public database like linkorcl（创建的link名称） connect to zhang（用户名） identified by xxxx（密码） using '111.111.1.1:1521/orcl'（远程数据库ip和数据库名称）; 其他均为关键字 第二、使用创建的li
方法如下：
第一、创建远程链接的link：
create public database like linkorcl（创建的link名称） connect to zhang（用户名） identified by
xxxx（密码） using  '111.111.1.1:1521/orcl'（远程数据库ip和数据库名称）;
其他均为关键字
第二、使用创建的link名称进行查询即可：
select * from student@linkorcl;
实例如下：
sql>
sql> create   public   database   link   linkorcl connect   to   zhang identified   by
  2  xxxx using   '111.111.1.1:1521/orcl';
database link created
sql> select * from student@linkorcl;
s_id                                                                             s_name                                             s_age
-------------------------------------------------------------------------------- -------------------------------------------------- -----
1                                                                                potter                                                26
2                                                                                马明                                                  21
3                                                                                张士波                                                12
4                                                                                renee                                                 15
5                                                                                reday                                                 18
6                                                                                alisa                                                 19
7                                                                                胡总                                                  23
8                                                                                阿里山                                                29
9                                                                                扎西                                                  20
10                                                                               香格里拉                                              24
11                                                                               琪琪格                                                28
12                                                                               暗夜精灵                                              19
12 rows selected
sql>