OracleDecimal Static (Manipulation) Methods

The OracleDecimal static (manipulation) methods are listed in Table 14-54.

Table 54 OracleDecimal Static (Manipulation) Methods

Methods Description
Abs Returns the absolute value of an OracleDecimal
Add Adds two OracleDecimal structures
AdjustScale Returns a new OracleDecimal with the specified number of digits and indicates whether or not to round or truncate the number if the scale is less than original
Ceiling Returns a new OracleDecimal structure with its value set to the ceiling of an OracleDecimal structure
ConvertToPrecScale Returns a new OracleDecimal structure with a new precision and scale
Divide Divides one OracleDecimal value by another
Floor Returns a new OracleDecimal structure with its value set to the floor of an OracleDecimal structure
Max Returns the maximum value of the two supplied OracleDecimal structures
Min Returns the minimum value of the two supplied OracleDecimal structures
Mod Returns a new OracleDecimal structure with its value set to the modulus of two OracleDecimal structures
Multiply Returns a new OracleDecimal structure with its value set to the result of multiplying two OracleDecimal structures
Negate Returns a new OracleDecimal structure with its value set to the negation of the supplied OracleDecimal structure
Parse Converts a string to an OracleDecimal
Round Returns a new OracleDecimal structure with its value set to that of the supplied OracleDecimal structure and rounded off to the specified place
SetPrecision Returns a new OracleDecimal structure with a new specified precision.
Shift Returns a new OracleDecimal structure with its value set to that of the supplied OracleDecimal structure, and its decimal place shifted to the specified number of places to the right
Sign Determines the sign of an OracleDecimal structure
Sqrt Returns a new OracleDecimal structure with its value set to the square root of the supplied OracleDecimal structure
Subtract Returns a new OracleDecimal structure with its value set to result of subtracting one OracleDecimal structure from another
Truncate Truncates the OracleDecimal at a specified position

See Also: