![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
LEFT JOIN ON
zyssnh51390
这个作者很懒,什么都没留下…
展开
-
SQL横向添加
select t.customer, count(t.customer) from tablea t where t.phoneno in ('777777', '222222') group by t.customer order by t.customer; select t.customer, count(t.customer) from tablea t where t.phone...原创 2012-04-27 14:18:07 · 153 阅读 · 0 评论 -
Oracle不安装服务端应用PL/SQL
1.首先到oracle的网站下载客户端文件,我下载的是instantclient-basic-nt-11.2.0.3.0.zip 下载地址: http://www.oracle.com/technetwork/cn/topics/winsoft-085727.html 2.解压下载的文件,假设保存目录为d:\oracle 3.在d:\oracle下新建目录 network...原创 2013-05-22 11:48:09 · 94 阅读 · 0 评论