oracle函数及触发器

oracle函数及触发器（共1篇）

1.oracle函数及触发器 篇一

sign

在Oracle/PLSQL中, sign 函数返回一个数字的正负标志.语法如下：sign(number)number 要测试标志的数字.If number < 0, then sign returns-1.If number = 0, then sign returns 0.If number > 0, then sign returns 1.应用于:  Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g 例如: 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)would return 1