daditao的专栏

http://www.cnblogs.com/ajian/archive/2009/03/25/1421063.html Oracle中TO_DATE格式 TO_DATE格式(以时间:2007-11-02   13:45:25为例)            Year:              yy two digits 两位年                显示值:0

http://blog.youkuaiyun.com/xpsharp/article/details/7678028 ORACLE JDBC的getGeneratedKeys 对于JDBC 3.0， 使用statement.getGeneratedKeys()可以返回刚刚插入的记录的自动增长的ID值。对于ORACLE，一般是定义一个序列，然后利用序列的nextval来自动给列分配ID值。但是很多人

http://www.cnblogs.com/rootq/articles/1100086.html //1、call＋包名＋存储过程名（传入、传出值用？）      String str="{call SMSBUSINESS.deleteZhZMember(?,?,?)}"; //2、建立连接  Connection conn=null;  conn=DriverManager.g

http://www.cnblogs.com/rainman/archive/2013/05/01/3053703.html 1、概述2、原始表3、简单Group By4、Group By 和 Order By5、Group By中Select指定的字段限制6、Group By All7、Group By与聚合函数8、Having与Where的区别9、Compute

select cast(Startpos as integer) from Message_Rule Where Texttype='612'        Union        Select Startpos+(select max(cast(Endpos as Integer)) from Message_Rule where texttype='612') From Message_