全部博文
-
编辑 删除
使用Oracle的Decode函数进行多值判断
Decode函数的语法结构如下: decode (expression_r, search_1, result_1) decode (expression_r, search_1, result_1, search_2, result_2) decode (expression_r, search_1, result_1, search_2, result_2, ...., search_n, result_n) decode (expression_r, search_1, result_1, default) decode (expression_r, search_1, result_1, search_2, result_2, default) decode (expression_r, search_1, result_1, search_2, result_2, ...., search_n, result_n, default) decode函数比较表达式和搜索字，如果匹配，返回结果；如
