<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Cming_Du的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/Cming_Du</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; Cming_Du]]></copyright><item><title><![CDATA[SpringMvc + ajax 文件上传]]></title><link>https://blog.youkuaiyun.com/Cming_Du/article/details/44926023</link><guid>https://blog.youkuaiyun.com/Cming_Du/article/details/44926023</guid><author>Cming_Du</author><pubDate>Tue, 07 Apr 2015 21:30:58 +0800</pubDate><description><![CDATA[１、依赖的jar包 【commons-io-1.4.jar】、【commons-fileupload-1.2.1.jar】
2、spring.xml 配置：




xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
xmln]]></description><category></category></item><item><title><![CDATA[java中处理Excel]]></title><link>https://blog.youkuaiyun.com/Cming_Du/article/details/7869421</link><guid>https://blog.youkuaiyun.com/Cming_Du/article/details/7869421</guid><author>Cming_Du</author><pubDate>Wed, 15 Aug 2012 15:39:26 +0800</pubDate><description><![CDATA[package com.hm.pro.util.excel;

import org.apache.commons.lang.StringUtils;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.apache.poi.hssf.usermod]]></description><category></category></item><item><title><![CDATA[技巧 SQL分享]]></title><link>https://blog.youkuaiyun.com/Cming_Du/article/details/7869366</link><guid>https://blog.youkuaiyun.com/Cming_Du/article/details/7869366</guid><author>Cming_Du</author><pubDate>Wed, 15 Aug 2012 15:32:47 +0800</pubDate><description><![CDATA[Ø进线SQL1
SELECT SUBSTR(C.STIME, 9, 2) || ':' || SUBSTR(C.STIME,11, 2) HHMM,
             NVL(B.CALLIN_QTY, 0) CALLIN_QTY
             FROM (SELECT TO_CHAR(TO_DATE(#REAL_END_TIME#, 'yyyy-mm-dd hh24:m]]></description><category></category></item><item><title><![CDATA[检测数据是否对应]]></title><link>https://blog.youkuaiyun.com/Cming_Du/article/details/7869351</link><guid>https://blog.youkuaiyun.com/Cming_Du/article/details/7869351</guid><author>Cming_Du</author><pubDate>Wed, 15 Aug 2012 15:29:48 +0800</pubDate><description><![CDATA[•检查数据总数是否对应，以及各条件（如状态）数据量是否对应
•检查是否有重复值。如下检查分类下属性是否重名。
SELECT A.Expl_Seq,A.Option_Nm,MIN(A.Option_Seq),MAX(A.Option_Seq),COUNT(1)

FROM TB_EXPL_OPTION A
GROUP BY A.EXPL_SEQ,A.OPTION_NM
HAVING CO]]></description><category></category></item><item><title><![CDATA[导入数据]]></title><link>https://blog.youkuaiyun.com/Cming_Du/article/details/7869342</link><guid>https://blog.youkuaiyun.com/Cming_Du/article/details/7869342</guid><author>Cming_Du</author><pubDate>Wed, 15 Aug 2012 15:28:30 +0800</pubDate><description><![CDATA[Ø数据源为EXCEL:
•直接从EXCEL 
复制到临时表，再写SQL导入。
•利用EXCEL本身函数功能生在SQL语句。
Ø数据源为另一个ORACLE
•Dblink方式
•数据库备份方式
Ø数据源为异构数据库
•小数据量用EXCEL做为中转站
•对于大数据量还是用程序，对于两边表结构不一样，先写入到ORACLE，再用SQL在ORACLE转换。
Ø学会使用临时表
    C]]></description><category></category></item><item><title><![CDATA[oracle-造数据]]></title><link>https://blog.youkuaiyun.com/Cming_Du/article/details/7869332</link><guid>https://blog.youkuaiyun.com/Cming_Du/article/details/7869332</guid><author>Cming_Du</author><pubDate>Wed, 15 Aug 2012 15:26:37 +0800</pubDate><description><![CDATA[Ø选择最合适的数据源表
Ø利用dbms_random.value()、SYSDATE、ROWNUM、TRUNC等产生随机数，让数据更逼真。
Ø示例
INSERT INTO TB_COMIT_MAS 
        (COMIT_ID, COMIT_TITLE, CHNL_LGROUP, COMIT_TYPE_CD,
         CONTENT, COMIT_STAT_CD, SC]]></description><category></category></item><item><title><![CDATA[oracle  一些高级用法]]></title><link>https://blog.youkuaiyun.com/Cming_Du/article/details/7869323</link><guid>https://blog.youkuaiyun.com/Cming_Du/article/details/7869323</guid><author>Cming_Du</author><pubDate>Wed, 15 Aug 2012 15:25:33 +0800</pubDate><description><![CDATA[随机返回5条记录，抽奖的时候挺好用。
SELECT *   FROM(SELECT A.PROD_ID, A.PROD_NAME
          FROMTB_PROD_MAS A
         ORDER BYDBMS_RANDOM.VALUE())
 WHERE ROWNUM
查询跳过表中的偶数行
SELECT   X.*
  FROM (SELECTROW_NUMBER]]></description><category></category></item><item><title><![CDATA[oracle-新特性]]></title><link>https://blog.youkuaiyun.com/Cming_Du/article/details/7869296</link><guid>https://blog.youkuaiyun.com/Cming_Du/article/details/7869296</guid><author>Cming_Du</author><pubDate>Wed, 15 Aug 2012 15:23:15 +0800</pubDate><description><![CDATA[ORACLE一些特性1
ROWNUM:表示行号，实际上此是一个列，但是这个列是一个伪列，此列可以在每张表中出现,ORACLE的分页一般用ROWNUM实现。不像MYSQL的LIMIT,于MSSQL的TOP.
SELECT B.PROD_ID,B.PROD_NAME
FROM (SELECT ROWNUM RN,A.*
          FROMTB_PROD_MAS A WHERE ROW]]></description><category></category></item><item><title><![CDATA[Ø集合操作]]></title><link>https://blog.youkuaiyun.com/Cming_Du/article/details/7869203</link><guid>https://blog.youkuaiyun.com/Cming_Du/article/details/7869203</guid><author>Cming_Du</author><pubDate>Wed, 15 Aug 2012 15:07:09 +0800</pubDate><description><![CDATA[UNION：将多个查询的结果组合到一个查询结果之中，没有重复内容;
UNION ALL：跟UNION一样，但是包含重复值;

INTERSECT：返回多个查询结果中相同的部分;
MINUS：返回两个查询结果的差集;
UNION,UNION  ALL 
区别SQL体现
SELECT 'UNION_COUNT' TYPE, COUNT(1) QTY
  FROM (SELECTA.PR]]></description><category></category></item><item><title><![CDATA[基本查询语句格式格式]]></title><link>https://blog.youkuaiyun.com/Cming_Du/article/details/7841613</link><guid>https://blog.youkuaiyun.com/Cming_Du/article/details/7841613</guid><author>Cming_Du</author><pubDate>Wed, 08 Aug 2012 07:43:37 +0800</pubDate><description><![CDATA[SELECT{DISTINCT} * | 查询列1 
别名 1,查询列2 
别名 2,…
FROM  表名称别名
{WHERE  条件(s)}
{ORDER BY 排序字段ASC|DESC, 
排序字段ACS | DESC ,…}
思考： DISTINCT可以去重，GROUP BY分组后也可以，有什么区别呢？
SELECTDISTINCT PROD_ID,UNIT_ID,A.Pro]]></description><category></category></item></channel></rss>