ORACLE常用SQL
-
Java Oracle char转varchar2 查询映射实体类
select cast('常量' AS varchar2(10) ) 转换后别名 from 表名;
- 查询当前日期之前的12个月
SELECT TO_CHAR (ADD_MONTHS (SYSDATE, -ROWNUM + 1), 'yyyy-MM') day
FROM DUAL CONNECT BY 12 >= ROWNUM;
JAVA基础操作
- 字符串数组/字符串转换
String str = StringUtils.join(strArray,",");
String[] strArray = str.split(",");