从一个库中查询另一个库中的表可以用database link
使用:
select account_id from chargerate@account where rate>0.1) and t.SCORE is null;
创建:
CREATE DATABASE LINK "NewDatabaseLink" CONNECT TO "username" IDENTIFIED BY "password" USING 'dbname';
从一个库中查询另一个库中的表可以用database link
使用:
select account_id from chargerate@account where rate>0.1) and t.SCORE is null;
创建:
CREATE DATABASE LINK "NewDatabaseLink" CONNECT TO "username" IDENTIFIED BY "password" USING 'dbname';