随笔分类 -  SQL

数据库相关
一个with as的oracle应用
摘要：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 阅读(443) 评论(0) 推荐(0)
Oracle创建库连接
摘要：注意的是引号的应用，容易出错：CREATE DATABASE LINK NWKEDIT CONNECT TO username IDENTIFIED BY password USING 'ip:port/SID';连接名：NWKEDIT，用户名：username，密码：password 阅读全文
posted @ 2014-11-24 13:07 aneo 阅读(250) 评论(0) 推荐(0)