Export (0) Print
Expand All

OracleNumber Structure

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)

public value class OracleNumber : IComparable, 
	INullable

The OracleNumber type exposes the following members.

  NameDescription
Public methodOracleNumber(Decimal)Initializes a new instance of the OracleNumber structure using the supplied Decimal value.
Public methodOracleNumber(Double)Initializes a new instance of the OracleNumber using the supplied double precision value.
Public methodOracleNumber(Int32)Initializes a new instance of the OracleNumber structure using the supplied integer value.
Public methodOracleNumber(Int64)Initializes a new instance of the OracleNumber structure using the supplied long integer value.
Public methodOracleNumber(OracleNumber)Initializes a new instance of the OracleNumber structure using the supplied OracleNumber.
Top

  NameDescription
Public propertyIsNullIndicates whether or not the Value of this OracleNumber structure is null.
Public propertyValueGets the value of the OracleNumber structure. This property is read-only.
Top

  NameDescription
Public methodStatic memberAbsGets the absolute value of the OracleNumber parameter.
Public methodStatic memberAcosCalculates the inverse hyperbolic cosine of an OracleNumber.
Public methodStatic memberAddCalculates the sum of the two OracleNumber structures.
Public methodStatic memberAsinCalculates the inverse hyperbolic sine of an OracleNumber.
Public methodStatic memberAtanCalculates the inverse hyperbolic tangent of an OracleNumber.
Public methodStatic memberAtan2Calculates the inverse hyperbolic tangent of two OracleNumber structures.
Public methodStatic memberCeilingReturns the smallest whole number greater than or equal to the specified OracleNumber structure.
Public methodCompareToCompares this instance of the OracleNumber structure to the supplied object and returns an indication of their relative values.
Public methodStatic memberCosCalculates the cosine of an OracleNumber.
Public methodStatic memberCoshCalculates the hyperbolic cosine of an OracleNumber.
Public methodStatic memberDivideCalculates the results of dividing the first OracleNumber structure by the second.
Public methodEquals(Object)Compares the supplied object parameter to the Value property of the OracleNumber object. (Overrides ValueType::Equals(Object).)
Public methodStatic memberEquals(OracleNumber, OracleNumber)Performs a logical comparison of the two OracleNumber structures to determine if they are equal.
Public methodStatic memberExpCalculates e raised to the power of an OracleNumber. The constant e equals 2.71828182845904, the base of the natural logarithm.
Public methodStatic memberFloorRounds a specified OracleNumber number to the next lower whole number.
Public methodGetHashCodeReturns the hash code for this instance of the OracleNumber structure. (Overrides ValueType::GetHashCode().)
Public methodGetTypeGets the Type of the current instance. (Inherited from Object.)
Public methodStatic memberGreaterThanPerforms a logical comparison of two OracleNumber structures to determine whether the first is greater than the second.
Public methodStatic memberGreaterThanOrEqualPerforms a logical comparison of the two OracleNumber parameters to determine whether the first is greater than or equal to the second.
Public methodStatic memberLessThanPerforms a logical comparison of two OracleNumber structures to determine whether the first is less than the second.
Public methodStatic memberLessThanOrEqualPerforms a logical comparison of the two OracleNumber parameters to determine whether the first is less than or equal to the second.
Public methodStatic memberLog(OracleNumber)Calculates natural logarithm of an OracleNumber. Natural logarithms are based on the constant e (2.71828182845904).
Public methodStatic memberLog(OracleNumber, OracleNumber)Calculates an OracleNumber to the base you specify.
Public methodStatic memberLog(OracleNumber, Int32)Calculates an OracleNumber to the base you specify.
Public methodStatic memberLog10Calculates the base 10 logarithm of a number.
Public methodStatic memberMaxReturns the larger of the two OracleNumber parameter values.
Public methodStatic memberMinReturns the smaller of the two OracleNumber parameter values.
Public methodStatic memberModuloCalculates the modulus from dividing the first OracleNumber structure by the second.
Public methodStatic memberMultiplyCalculates the product of the two OracleNumber parameters.
Public methodStatic memberNegateNegates the value of the OracleNumber parameter.
Public methodStatic memberNotEqualsPerforms a logical comparison of the two OracleNumber parameters to determine whether they are not equal.
Public methodStatic memberParseConverts the String representation of a number to its OracleNumber equivalent.
Public methodStatic memberPow(OracleNumber, OracleNumber)Calculates the result of raising a specified OracleNumber structure to the power specified by a second OracleNumber structure.
Public methodStatic memberPow(OracleNumber, Int32)Calculates the result of raising a specified OracleNumber structure to the power specified by an Int32 structure.
Public methodStatic memberRoundGets the number nearest the specified OracleNumber structure's value with the specified precision.
Public methodStatic memberShiftShifts the specified number of digits to the left or right.
Public methodStatic memberSignGets a value indicating the sign of an OracleNumber structure's Value property.
Public methodStatic memberSinCalculates the sine of an OracleNumber.
Public methodStatic memberSinhCalculates the hyperbolic sine of an OracleNumber.
Public methodStatic memberSqrtCalculates the square root of the OracleNumber parameter.
Public methodStatic memberSubtractCalculates the result of subtracting the second OracleNumber structure from the first.
Public methodStatic memberTanCalculates the tangent of an OracleNumber.
Public methodStatic memberTanhCalculates the hyperbolic tangent of an OracleNumber.
Public methodToStringConverts this OracleNumber structure to String. (Overrides ValueType::ToString().)
Public methodStatic memberTruncateTruncates the specified OracleNumber structure's value to the desired position.
Top

  NameDescription
Public operatorStatic memberAdditionCalculates the sum of the two OracleNumber structures.
Public operatorStatic memberDivisionCalculates the results of dividing the first OracleNumber structure by the second.
Public operatorStatic memberEqualityPerforms a logical comparison of the two OracleNumber structures to determine whether they are equal.
Public operatorStatic memberExplicit(Decimal to OracleNumber)Converts the supplied Decimal structure to an OracleNumber structure.
Public operatorStatic memberExplicit(Double to OracleNumber)Converts the supplied Double structure to an OracleNumber structure.
Public operatorStatic memberExplicit(Int32 to OracleNumber)Converts the supplied Int32 structure to an OracleNumber structure.
Public operatorStatic memberExplicit(Int64 to OracleNumber)Converts the supplied Int64 structure to an OracleNumber structure.
Public operatorStatic memberExplicit(OracleNumber to Int32)Converts the OracleNumber structure to Int32.
Public operatorStatic memberExplicit(OracleNumber to Int64)Converts the OracleNumber structure to Int64.
Public operatorStatic memberExplicit(OracleNumber to Decimal)Converts the OracleNumber structure to Decimal.
Public operatorStatic memberExplicit(OracleNumber to Double)Converts the OracleNumber structure to Double.
Public operatorStatic memberExplicit(String to OracleNumber)Converts the supplied String to an OracleNumber structure.
Public operatorStatic memberGreaterThanPerforms a logical comparison of two OracleNumber structures to determine whether the first is greater than the second.
Public operatorStatic memberGreaterThanOrEqualPerforms a logical comparison of the two OracleNumber parameters to determine whether the first is greater than or equal to the second.
Public operatorStatic memberInequalityPerforms a logical comparison of the two OracleNumber parameters to determine whether they are equal.
Public operatorStatic memberLessThanPerforms a logical comparison of two OracleNumber structures to determine whether the first is less than the second.
Public operatorStatic memberLessThanOrEqualPerforms a logical comparison of the two OracleNumber parameters to determine whether the first is less than or equal to the second.
Public operatorStatic memberModulusCalculates the remainder left over from dividing an OracleNumber structure by a second OracleNumber structure.
Public operatorStatic memberMultiplyCalculates the product of two OracleNumber structures.
Public operatorStatic memberSubtractionCalculates the result of subtracting the second OracleNumber structure from the first.
Public operatorStatic memberUnaryNegationNegates the OracleNumber structure.
Top

  NameDescription
Public fieldStatic memberEReturns the value e-2.718.
Public fieldStatic memberMaxPrecisionA constant representing the largest possible value for precision comparison.
Public fieldStatic memberMaxScaleA constant representing the maximum value for scale comparison.
Public fieldStatic memberMaxValueA constant representing the maximum value of an OracleNumber structure.
Public fieldStatic memberMinScaleA constant representing the minimum value for scale comparison.
Public fieldStatic memberMinusOneReturns the value -1.
Public fieldStatic memberMinValueA constant representing the minimum value for an OracleNumber structure.
Public fieldStatic memberNullRepresents a null value that can be assigned to the Value property of an instance of the OracleNumber class.
Public fieldStatic memberOneReturns the value 1.
Public fieldStatic memberPIReturns the value of pi-3.1415926535897932384626433832795028842.
Public fieldStatic memberZeroReturns the value 0.
Top

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.

.NET Framework

Supported in: 4.5.2, 4.5.1, 4.5, 4, 3.5, 3.0, 2.0, 1.1

Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Show:
© 2014 Microsoft