DBlink 入门案例

    SELECT id,
       request_no,
       push_url,
       push_type,
       to_char(push_time, 'YYYY-MM-DD HH24:MI:SS'),
       '催收系统' sys_name
  FROM ct_t_cn_push_mes@CREDIT_COLLECTION
 where push_status = '推送失败'
UNION
SELECT id,
       request_no,
       push_url,
       push_type,
       to_char(push_time, 'YYYY-MM-DD HH24:MI:SS'),
       '审核系统' sys_name
  FROM ct_t_at_push_mes@credit_audit
 where push_status = '推送失败'

注意：DBlink不能查询出clob类型的字段

在当前数据库下查看所有的DBLINK的方法：elect * from dba_db_links;