# OracleNumber Structure

.NET Framework (current version)

Note

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

Represents a fixed precision and scale numeric value between -10 27 -1 and 10 27 -1 to be stored in or retrieved from a database.

Namespace:   System.Data.OracleClient
Assembly:  System.Data.OracleClient (in System.Data.OracleClient.dll)

## Syntax

```Public Structure OracleNumber
Implements IComparable, INullable
```

## Constructors

NameDescription
OracleNumber(Decimal)

Initializes a new instance of the OracleNumber structure using the supplied Decimal value.

OracleNumber(Double)

Initializes a new instance of the OracleNumber using the supplied double precision value.

OracleNumber(Int32)

Initializes a new instance of the OracleNumber structure using the supplied integer value.

OracleNumber(Int64)

Initializes a new instance of the OracleNumber structure using the supplied long integer value.

OracleNumber(OracleNumber)

Initializes a new instance of the OracleNumber structure using the supplied OracleNumber.

## Properties

NameDescription
IsNull

Indicates whether or not the Value of this OracleNumber structure is null.

Value

Gets the value of the OracleNumber structure. This property is read-only.

## Methods

NameDescription
Abs(OracleNumber)

Gets the absolute value of the OracleNumber parameter.

Acos(OracleNumber)

Calculates the inverse hyperbolic cosine of an OracleNumber.

Calculates the sum of the two OracleNumber structures.

Asin(OracleNumber)

Calculates the inverse hyperbolic sine of an OracleNumber.

Atan(OracleNumber)

Calculates the inverse hyperbolic tangent of an OracleNumber.

Atan2(OracleNumber, OracleNumber)

Calculates the inverse hyperbolic tangent of two OracleNumber structures.

Ceiling(OracleNumber)

Returns the smallest whole number greater than or equal to the specified OracleNumber structure.

CompareTo(Object)

Compares this instance of the OracleNumber structure to the supplied object and returns an indication of their relative values.

Cos(OracleNumber)

Calculates the cosine of an OracleNumber.

Cosh(OracleNumber)

Calculates the hyperbolic cosine of an OracleNumber.

Divide(OracleNumber, OracleNumber)

Calculates the results of dividing the first OracleNumber structure by the second.

Equals(Object)

Compares the supplied object parameter to the Value property of the OracleNumber object.(Overrides ValueType.Equals(Object).)

Equals(OracleNumber, OracleNumber)

Performs a logical comparison of the two OracleNumber structures to determine if they are equal.

Exp(OracleNumber)

Calculates e raised to the power of an OracleNumber. The constant e equals 2.71828182845904, the base of the natural logarithm.

Floor(OracleNumber)

Rounds a specified OracleNumber number to the next lower whole number.

GetHashCode()

Returns the hash code for this instance of the OracleNumber structure.(Overrides ValueType.GetHashCode().)

GetType()

Gets the Type of the current instance.(Inherited from Object.)

GreaterThan(OracleNumber, OracleNumber)

Performs a logical comparison of two OracleNumber structures to determine whether the first is greater than the second.

GreaterThanOrEqual(OracleNumber, OracleNumber)

Performs a logical comparison of the two OracleNumber parameters to determine whether the first is greater than or equal to the second.

LessThan(OracleNumber, OracleNumber)

Performs a logical comparison of two OracleNumber structures to determine whether the first is less than the second.

LessThanOrEqual(OracleNumber, OracleNumber)

Performs a logical comparison of the two OracleNumber parameters to determine whether the first is less than or equal to the second.

Log(OracleNumber)

Calculates natural logarithm of an OracleNumber. Natural logarithms are based on the constant e (2.71828182845904).

Log(OracleNumber, Int32)

Calculates an OracleNumber to the base you specify.

Log(OracleNumber, OracleNumber)

Calculates an OracleNumber to the base you specify.

Log10(OracleNumber)

Calculates the base 10 logarithm of a number.

Max(OracleNumber, OracleNumber)

Returns the larger of the two OracleNumber parameter values.

Min(OracleNumber, OracleNumber)

Returns the smaller of the two OracleNumber parameter values.

Modulo(OracleNumber, OracleNumber)

Calculates the modulus from dividing the first OracleNumber structure by the second.

Multiply(OracleNumber, OracleNumber)

Calculates the product of the two OracleNumber parameters.

Negate(OracleNumber)

Negates the value of the OracleNumber parameter.

NotEquals(OracleNumber, OracleNumber)

Performs a logical comparison of the two OracleNumber parameters to determine whether they are not equal.

Parse(String)

Converts the String representation of a number to its OracleNumber equivalent.

Pow(OracleNumber, Int32)

Calculates the result of raising a specified OracleNumber structure to the power specified by an Int32 structure.

Pow(OracleNumber, OracleNumber)

Calculates the result of raising a specified OracleNumber structure to the power specified by a second OracleNumber structure.

Round(OracleNumber, Int32)

Gets the number nearest the specified OracleNumber structure's value with the specified precision.

Shift(OracleNumber, Int32)

Shifts the specified number of digits to the left or right.

Sign(OracleNumber)

Gets a value indicating the sign of an OracleNumber structure's Value property.

Sin(OracleNumber)

Calculates the sine of an OracleNumber.

Sinh(OracleNumber)

Calculates the hyperbolic sine of an OracleNumber.

Sqrt(OracleNumber)

Calculates the square root of the OracleNumber parameter.

Subtract(OracleNumber, OracleNumber)

Calculates the result of subtracting the second OracleNumber structure from the first.

Tan(OracleNumber)

Calculates the tangent of an OracleNumber.

Tanh(OracleNumber)

Calculates the hyperbolic tangent of an OracleNumber.

ToString()

Converts this OracleNumber structure to String.(Overrides ValueType.ToString().)

Truncate(OracleNumber, Int32)

Truncates the specified OracleNumber structure's value to the desired position.

## Fields

NameDescription
E

Returns the value e-2.718.

MaxPrecision

A constant representing the largest possible value for precision comparison.

MaxScale

A constant representing the maximum value for scale comparison.

MaxValue

A constant representing the maximum value of an OracleNumber structure.

MinScale

A constant representing the minimum value for scale comparison.

MinusOne

Returns the value -1.

MinValue

A constant representing the minimum value for an OracleNumber structure.

Null

Represents a null value that can be assigned to the Value property of an instance of the OracleNumber class.

One

Returns the value 1.

PI

Returns the value of pi-3.1415926535897932384626433832795028842.

Zero

Returns the value 0.

## Operators

NameDescription

Calculates the sum of the two OracleNumber structures.

Division(OracleNumber, OracleNumber)

Calculates the results of dividing the first OracleNumber structure by the second.

Equality(OracleNumber, OracleNumber)

Performs a logical comparison of the two OracleNumber structures to determine whether they are equal.

Narrowing(Decimal to OracleNumber)

Converts the supplied Decimal structure to an OracleNumber structure.

Narrowing(Double to OracleNumber)

Converts the supplied Double structure to an OracleNumber structure.

Narrowing(Int32 to OracleNumber)

Converts the supplied Int32 structure to an OracleNumber structure.

Narrowing(Int64 to OracleNumber)

Converts the supplied Int64 structure to an OracleNumber structure.

Narrowing(OracleNumber to Decimal)

Converts the OracleNumber structure to Decimal.

Narrowing(OracleNumber to Double)

Converts the OracleNumber structure to Double.

Narrowing(OracleNumber to Int32)

Converts the OracleNumber structure to Int32.

Narrowing(OracleNumber to Int64)

Converts the OracleNumber structure to Int64.

Narrowing(String to OracleNumber)

Converts the supplied String to an OracleNumber structure.

GreaterThan(OracleNumber, OracleNumber)

Performs a logical comparison of two OracleNumber structures to determine whether the first is greater than the second.

GreaterThanOrEqual(OracleNumber, OracleNumber)

Performs a logical comparison of the two OracleNumber parameters to determine whether the first is greater than or equal to the second.

Inequality(OracleNumber, OracleNumber)

Performs a logical comparison of the two OracleNumber parameters to determine whether they are equal.

LessThan(OracleNumber, OracleNumber)

Performs a logical comparison of two OracleNumber structures to determine whether the first is less than the second.

LessThanOrEqual(OracleNumber, OracleNumber)

Performs a logical comparison of the two OracleNumber parameters to determine whether the first is less than or equal to the second.

Modulus(OracleNumber, OracleNumber)

Calculates the remainder left over from dividing an OracleNumber structure by a second OracleNumber structure.

Multiply(OracleNumber, OracleNumber)

Calculates the product of two OracleNumber structures.

Subtraction(OracleNumber, OracleNumber)

Calculates the result of subtracting the second OracleNumber structure from the first.

UnaryNegation(OracleNumber)

Negates the OracleNumber structure.

## Remarks

To obtain an OracleNumber object, call the GetOracleNumber method.

Oracle numeric data types can store up to 27 decimal digits of precision. When converting Oracle numeric values to common language runtime data types, the Oracle value might be too large. Conversely, when converting a numeric value of a common language runtime data types to an OracleNumber, the numeric value may be either too large or too high precision for the OracleNumber. Either of these cases will cause an Oracle ORA-22053 overflow error. If your Oracle database might contain large values, you should use the OracleNumber data type. You can then convert to the common language runtime data type explicitly, and catch or handle any errors.

## Version Information

.NET Framework
Available since 1.1