用数据库链节怎么样?CREATE DATABASE LINK WY --dblink name
CONNECT TO SYSTEM --user name
IDENTIFIED BY MANAGER --password
USING '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = IP address)(PORT = 1521)) (CONNECT_DATA = (SID = dbsid)))'
/
CONNECT TO SYSTEM --user name
IDENTIFIED BY MANAGER --password
USING '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = IP address)(PORT = 1521)) (CONNECT_DATA = (SID = dbsid)))'
/
EXEC SQL BEGIN DECLARE SECTION;
char con_test1[] ="user1/pass1@test1";
char db_test1[]="db_test1";
char con_test2[] ="user2/pass2@test2";
char db_test2[]="db_test2";
EXEC SQL END DECLARE SECTION;
EXEC SQL CONNECT :con_test1 at :db_test1;
EXEC SQL CONNECT :con_test2 at :db_test2; EXEC SQL at :db_test1 UPDATE tab1 set col1='table at database test1';
EXEC SQL at :db_test2 update tab2 set col1='tabel at database test2';
如 select 数据库.表.字段 from 数据库.表 where .....
当然,所在库下操作,不用加数据库.
哪test2在哪添加?怎么定义?