CREATE DATABASE LINK语法: CREATE [PUBLIC] DATABASE LINK link CONNECT TO user IDENTIFIED BY password USING ‘connect_string’ 变量: link:数据库链名 user:数据库用户 password:有效的口令 connect_string:被访问的远程数据库字串 例子: SQL CREATE DATABASE LINK international_customers connect to INTL_DB identified by intl using ‘D:INTERNATIONAL’; SELECT CUSTOMER_NAME FROM CUSTOMER@INTL_DB;.
create database link link_name connect to 用户名 identified by 密码 using '全局数据库名'select * from table@link_name;
CREATE [PUBLIC] DATABASE LINK link
CONNECT TO user IDENTIFIED
BY password USING ‘connect_string’
变量:
link:数据库链名
user:数据库用户
password:有效的口令
connect_string:被访问的远程数据库字串
例子:
SQL
CREATE DATABASE LINK international_customers connect to INTL_DB
identified by intl using ‘D:INTERNATIONAL’;
SELECT CUSTOMER_NAME FROM CUSTOMER@INTL_DB;.
connect to 用户名 identified by 密码
using '全局数据库名'select * from table@link_name;