摘要: with tmp1 as (selectt."ID",t.userName,t.productId,t.operateId,t.normalIds,t.operateTimefrom trsaaa_statisticripeData t left join idsuser t2 on t.usern... 阅读全文
posted @ 2014-11-24 20:48 aneo 阅读(420) 评论(0) 推荐(0) 编辑
摘要: 注意的是引号的应用,容易出错:CREATE DATABASE LINK NWKEDIT CONNECT TO username IDENTIFIED BY password USING 'ip:port/SID';连接名:NWKEDIT,用户名:username,密码:password 阅读全文
posted @ 2014-11-24 13:07 aneo 阅读(249) 评论(0) 推荐(0) 编辑