在 Oracle/PLSQL, sign 函數(shù)返回一個(gè)值來說明數(shù)字的符號(hào)，語法如下 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 |
|
|
