先建好固定用户的数据库链接(Fixed user database link),然后对该用户名下的表直接引用:
select * from tab@db_link_name。建dblink的语法是;
create [public] database link db_link_name connect to username identified by password using 'connnect string';
select * from tab@db_link_name。建dblink的语法是;
create [public] database link db_link_name connect to username identified by password using 'connnect string';
varchar str_conn[20];
EXEC SQL END DECLARE SECTION; strcpy(str_conn.arr,"scott/tiger@DEMO");
str_conn.len=16;
exec sql connect :str_conn;