在 Oracle/PLSQL, sign 函数返回一个值来说明数字的符号，语法如下 sign( number ) If number < 0, then sign returns -1. If number = 0, then sign returns 0. If number > 0, then sign returns 1. For example: 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 sign(23.601) would return 1 |
|
|
