oracle函数学习记录

decode：

SELECT

available,

decode(available,0,'失效',1,'有效')

from TABLE;

PS:如果available=0，返回‘失效’

||：select id||'_1' id from table

ps:返回的结果为id_1

nvl  通过查询获取某个字段的合计值，如果为空，则赋与一个默认值

SELECT

NVL (MAX(ORDER_NUM), 0) + 1 AS MAXORDERNUM

FROM

AMS_APP_POINTS_INFO