Wednesday, October 17, 2007

ORCL - Functions

Oracle/PLSQL Functions
--------------------------------------------------------------------------------
Sign Function
In Oracle/PLSQL, the sign function returns a value indicating the sign of a number.
The syntax for the sign function is:
sign( number )
number is the number to test for its sign.
If number < 0, then sign returns -1.
If number = 0, then sign returns 0.
If number > 0, then sign returns 1.
Applies To: Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g
Example:
select (( SIGN( SIGN(NVL(tP.xsequence, 0) - NVL(PR.xsequence, 0)) + 1)
* NVL(tP.xsequence, 0)) +
( SIGN( SIGN(NVL(PR.xsequence, 0) - NVL(tP.xsequence,0)) + 1)
* NVL(PR.xsequence, 0) )) + 1, tp.xsequence, pr.xsequence
from tP, PR
where tP.P_Number = pr.p_number
--------------------------------------------------------------------------------

No comments:

Post a Comment