SQL 21 日自学通(V1.0) 翻译人 笨猪
EMAIL wyhsillypig@163.com
日期/时间函数......................................................................................................... 66
ADD_MONTHS................................................................................................ 67
LAST_DAY...................................................................................................... 68
MONTHS_BETWEEN....................................................................................... 69
NEW_TIME...................................................................................................... 70
NEXT_DAY...................................................................................................... 71
SYSDATE......................................................................................................... 72
数学函数................................................................................................................. 72
ABS ................................................................................................................. 73
CEIL 和 FLOOR ............................................................................................... 73
COS COSH SIN SINH TAN TANH........................................................ 73
EXP................................................................................................................. 75
LN and LOG..................................................................................................... 75
MOD................................................................................................................ 76
POWER............................................................................................................ 77
SIGN ............................................................................................................... 77
SQRT ............................................................................................................... 78
字符函数................................................................................................................. 79
CHR................................................................................................................. 79
CONCAT .......................................................................................................... 79
INITCAP.......................................................................................................... 80
LOWER 和 UPPER ........................................................................................... 81
LPAD 与 RPAD................................................................................................. 82
LTRIM 与 RTRIM............................................................................................. 83
REPLACE ........................................................................................................ 84
SUBSTR........................................................................................................... 85
TRANSLATE.................................................................................................... 88
INSTR............................................................................................................. 88
LENGTH.......................................................................................................... 89
转换函数................................................................................................................. 89
TO_CHAR........................................................................................................ 90
TO_NUMBER................................................................................................... 91
其它函数................................................................................................................. 91
GREATEST 与 LEAST...................................................................................... 91
USER............................................................................................................... 92
总结........................................................................................................................ 92
问与答.................................................................................................................... 93
校练场.................................................................................................................... 93
练习........................................................................................................................ 94
第五天 SQL 中的子句........................................................................................................... 95