/* 日期对象的下一个星期week的日期 */
Date NEXT_DAY(Date, String week)
示例:
SELECT NEXT_DAY(TO_DATE('2013-04-27', 'yyyy-mm-dd'), '星期一') FROM dual; /* 2013-04-29 */
Date TO_DATE(String date, String fmt) /* yyyy-mm-dd hh:mi:ss yyyy-mm-dd hh24:mi:ss <不支持毫秒> */
示例:
SELECT TO_DATE('2013-04-27 15:27:30', 'yyyy-mm-dd hh24:mi:ss') FROM dual; /* 2013/4/27 15:27:30 */
Number TO_NUMBER(String num_str)
Number TO-NUMBER(String, String fmt)
示例: /* 去掉前导 0 */
SELECT TO_NUMBER('07987984') FROM dual;
String TO_CHAR(Date, String fmt)
示例:
SELECT TO_CHAR(TO_DATE('2013-04-27','yyyy-mm-dd'), 'yyyy/mm/dd') FROM dual; /* 2013/04/27 */
String TO_CHAR(int, String fmt)
示例:
SELECT TO_CHAR(125, '99') FROM dual; /* ## */
SELECT TO_CHAR(125, '999') FROM dual; /* 125 */
SELECT TO_CHAR(125, '9999') FROM dual; /* 空格125 没有达到设置的长度用空格补齐 */
String TO_CHAR(float, String fmt)
示例:
SELECT TO_CHAR(125.098, '999D99') FROM dual; /* 125.10 */
String TO_CHAR(Number, String fmt)
示例:
String DUMP(String)
/* scale 8/10/16/17-单字符形式返回/1000 (1000加上以上4种值,在返回值中带上当前字符集) */
String DUMP(String, int scale)
SELECT DUMP('bcd') FROM dual; /* 默认是10进制 */
SELECT DUMP('bcd', 10) FROM dual; /* Typ=96 Len=3: 98,99,100 */
SELECT DUMP('bcd', 16) FROM dual; /* Typ=96 Len=3: 62,63,64 */
SELECT DUMP('bcd', 17) FROM dual; /* Typ=96 Len=3: b,c,d */
SELECT DUMP('bcd', 1016) FROM dual; /* Typ=96 Len=3 CharacterSet=ZHS16GBK: 62,63,64 */
Object GREATEST(Object, Object...)
Object LEAST(Object, Object...)
String ROWIDTOCHAR(ROWID)
String HEXTORAW(String hexStr)
示例: /* 16进制数字字符串 没有16进制前缀 */
SELECT HEXTORAW('a4564ff') FROM dual; /* 0A4564FF */
String RAWTOHEX(String)
/*====================================================*/
Oracle_常用属性
Date SYSDATE
long ROWNUM
RowId ROWID
String UID
String USER
Date NEXT_DAY(Date, String week)
示例:
SELECT NEXT_DAY(TO_DATE('2013-04-27', 'yyyy-mm-dd'), '星期一') FROM dual; /* 2013-04-29 */
Date TO_DATE(String date, String fmt) /* yyyy-mm-dd hh:mi:ss yyyy-mm-dd hh24:mi:ss <不支持毫秒> */
示例:
SELECT TO_DATE('2013-04-27 15:27:30', 'yyyy-mm-dd hh24:mi:ss') FROM dual; /* 2013/4/27 15:27:30 */
Number TO_NUMBER(String num_str)
Number TO-NUMBER(String, String fmt)
示例: /* 去掉前导 0 */
SELECT TO_NUMBER('07987984') FROM dual;
String TO_CHAR(Date, String fmt)
示例:
SELECT TO_CHAR(TO_DATE('2013-04-27','yyyy-mm-dd'), 'yyyy/mm/dd') FROM dual; /* 2013/04/27 */
String TO_CHAR(int, String fmt)
示例:
SELECT TO_CHAR(125, '99') FROM dual; /* ## */
SELECT TO_CHAR(125, '999') FROM dual; /* 125 */
SELECT TO_CHAR(125, '9999') FROM dual; /* 空格125 没有达到设置的长度用空格补齐 */
String TO_CHAR(float, String fmt)
示例:
SELECT TO_CHAR(125.098, '999D99') FROM dual; /* 125.10 */
String TO_CHAR(Number, String fmt)
示例:
String DUMP(String)
/* scale 8/10/16/17-单字符形式返回/1000 (1000加上以上4种值,在返回值中带上当前字符集) */
String DUMP(String, int scale)
SELECT DUMP('bcd') FROM dual; /* 默认是10进制 */
SELECT DUMP('bcd', 10) FROM dual; /* Typ=96 Len=3: 98,99,100 */
SELECT DUMP('bcd', 16) FROM dual; /* Typ=96 Len=3: 62,63,64 */
SELECT DUMP('bcd', 17) FROM dual; /* Typ=96 Len=3: b,c,d */
SELECT DUMP('bcd', 1016) FROM dual; /* Typ=96 Len=3 CharacterSet=ZHS16GBK: 62,63,64 */
Object GREATEST(Object, Object...)
Object LEAST(Object, Object...)
String ROWIDTOCHAR(ROWID)
String HEXTORAW(String hexStr)
示例: /* 16进制数字字符串 没有16进制前缀 */
SELECT HEXTORAW('a4564ff') FROM dual; /* 0A4564FF */
String RAWTOHEX(String)
/*====================================================*/
Oracle_常用属性
Date SYSDATE
long ROWNUM
RowId ROWID
String UID
String USER