Oracle的decode、sign、trunc函数

原文http://knowyouknowme.iteye.com/blog/574974

应用于

应用于:

例如:

      

sign(-23) would return -1 sign(0.001) would return -1 sign(0) would return 0 sign(0.001) would return 1 sign(23) would return 1 sig(23.601)

应用于:

例如For example:

trunc(125.815) would return 125 trunc(125.815, 0) would return 125 trunc(125.815, 1) would return 125.8 trunc(125.815, 2) would return 125.81 trunc(125.81, 3) would return 125.81 trunc(-125.815, 2) would return -125.81 trunc(125.815, -1) would return 120 trunc(125.815, -2) would return 100 trunc(125.81, -3) would return 0

 

 如果decimal_places 大于number 本身的小数位数，返回原数字不会加0.

如：trunc(125.81,3) would return 125.81;

如果decimal_places 为负数，那么将指定的位数

Oracle的decode、sign、trunc函数,布布扣,bubuko.com