https://blog.youkuaiyun.com/minsiqiangzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/minsiqiang/article/details/7207811https://blog.youkuaiyun.com/minsiqiang/article/details/7207811minsiqiangTue, 17 Jan 2012 19:03:07 +0800https://blog.youkuaiyun.com/minsiqiang/article/details/6430153https://blog.youkuaiyun.com/minsiqiang/article/details/6430153minsiqiangWed, 18 May 2011 17:16:00 +0800https://blog.youkuaiyun.com/minsiqiang/article/details/6429931https://blog.youkuaiyun.com/minsiqiang/article/details/6429931minsiqiangWed, 18 May 2011 16:14:00 +0800一、 常用日期数据格式

1.Y或YY或YYY 年的最后一位，两位或三位
SQL> Select to_char(sysdate,'Y') from dual;
TO_CHAR(SYSDATE,'Y')
--------------------
7
SQL> Select to_char(sysdate,'YY') from dual;
TO_CHAR(SYSDATE,'YY]]>https://blog.youkuaiyun.com/minsiqiang/article/details/5579779https://blog.youkuaiyun.com/minsiqiang/article/details/5579779minsiqiangTue, 11 May 2010 18:12:00 +0800https://blog.youkuaiyun.com/minsiqiang/article/details/5455233https://blog.youkuaiyun.com/minsiqiang/article/details/5455233minsiqiangTue, 06 Apr 2010 16:56:00 +0800 1)2、删除表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断，只留有rowid]]>https://blog.youkuaiyun.com/minsiqiang/article/details/5436676https://blog.youkuaiyun.com/minsiqiang/article/details/5436676minsiqiangWed, 31 Mar 2010 12:05:00 +0800https://blog.youkuaiyun.com/minsiqiang/article/details/5433553https://blog.youkuaiyun.com/minsiqiang/article/details/5433553minsiqiangTue, 30 Mar 2010 17:24:00 +0800https://blog.youkuaiyun.com/minsiqiang/article/details/5431637https://blog.youkuaiyun.com/minsiqiang/article/details/5431637minsiqiangTue, 30 Mar 2010 12:00:00 +0800https://blog.youkuaiyun.com/minsiqiang/article/details/5412700https://blog.youkuaiyun.com/minsiqiang/article/details/5412700minsiqiangWed, 24 Mar 2010 16:54:00 +0800https://blog.youkuaiyun.com/minsiqiang/article/details/5403509https://blog.youkuaiyun.com/minsiqiang/article/details/5403509minsiqiangMon, 22 Mar 2010 10:44:00 +0800https://blog.youkuaiyun.com/minsiqiang/article/details/5284472https://blog.youkuaiyun.com/minsiqiang/article/details/5284472minsiqiangWed, 03 Feb 2010 12:05:00 +0800https://blog.youkuaiyun.com/minsiqiang/article/details/5279377https://blog.youkuaiyun.com/minsiqiang/article/details/5279377minsiqiangTue, 02 Feb 2010 09:14:00 +0800 conditions) throws SQL]]>https://blog.youkuaiyun.com/minsiqiang/article/details/5277326https://blog.youkuaiyun.com/minsiqiang/article/details/5277326minsiqiangMon, 01 Feb 2010 15:22:00 +0800https://blog.youkuaiyun.com/minsiqiang/article/details/5219263https://blog.youkuaiyun.com/minsiqiang/article/details/5219263minsiqiangThu, 21 Jan 2010 09:40:00 +0800decode()函數使用技巧·软件环境： 1、Windows NT4.0+ORACLE 8.0.42、ORACLE安装路径为：C:/ORANT·含义解释： decode(条件,值1,翻译值1,值2,翻译值2,...值n,翻译值n,缺省值)该函数的含义如下：IF 条件=值1 THEN　　　　RETURN(翻译值1)ELSIF 条件=值2 THEN　　　　RETURN(翻译值2)　　　　....]]>https://blog.youkuaiyun.com/minsiqiang/article/details/5216358https://blog.youkuaiyun.com/minsiqiang/article/details/5216358minsiqiangWed, 20 Jan 2010 11:08:00 +0800https://blog.youkuaiyun.com/minsiqiang/article/details/5208727https://blog.youkuaiyun.com/minsiqiang/article/details/5208727minsiqiangMon, 18 Jan 2010 18:09:00 +0800https://blog.youkuaiyun.com/minsiqiang/article/details/5181911https://blog.youkuaiyun.com/minsiqiang/article/details/5181911minsiqiangTue, 12 Jan 2010 16:06:00 +0800https://blog.youkuaiyun.com/minsiqiang/article/details/5181751https://blog.youkuaiyun.com/minsiqiang/article/details/5181751minsiqiangTue, 12 Jan 2010 15:33:00 +0800https://blog.youkuaiyun.com/minsiqiang/article/details/5180847https://blog.youkuaiyun.com/minsiqiang/article/details/5180847minsiqiangTue, 12 Jan 2010 11:43:00 +0800import sun.misc.BASE64Decoder;import sun.misc.BASE64Encoder;public cl]]>https://blog.youkuaiyun.com/minsiqiang/article/details/5156691https://blog.youkuaiyun.com/minsiqiang/article/details/5156691minsiqiangFri, 08 Jan 2010 11:19:00 +0800