<br />字符串函数<br />函数：lower(char)<br />例子：select lower('DALiA') from dual;<br />显示：dalia<br /> <br /> <br />函数：replace(char, str1, str2)<br />例子：select replace('Scott', 'S', 'Boy') from dual;<br />显示：Boycott<br /> <br /> <br />函数：substr(char, m, n)<br />例子：s

create user cjl identified by "123456"; GRANT CONNECT TO "cjl"; GRANT CREATE TRIGGER TO "cjl"; GRANT DEBUG CONNECT SESSION TO "cjl"; GRANT C

sudo sh 在某处看到一篇介绍关于oracle- 11g xe在fedora上安装的文章，转载过来。 原文地址：http://blog.mclaughlinsoftware.com/2011/09/27/oracle-11g-xe-on-fedora/ 前5步是解压，省略... You need to drop down into a Terminal sess

String sql = "select count(*) from afpushmail_bill where to_date(Addtime) = to_date(?,'yyyy-MM-dd')"; return simpleJdbcTemplate.queryForInt(sql, DateFormatUtils.ISO_DATE_FORMAT.format(date));