OracleNumber OracleNumber OracleNumber OracleNumber Struct

定义

表示要存储在数据库中或从数据库中检索的固定精度和小数位数数值,该数值介于 -10 27 -1 和 10 27 -1 之间。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.

public value class OracleNumber : IComparable, System::Data::SqlTypes::INullable
public struct OracleNumber : IComparable, System.Data.SqlTypes.INullable
type OracleNumber = struct
    interface INullable
Public Structure OracleNumber
Implements IComparable, INullable
继承
OracleNumberOracleNumberOracleNumberOracleNumber
实现

注解

若要获取OracleNumber对象,请调用GetOracleNumber方法。To obtain an OracleNumber object, call the GetOracleNumber method.

Oracle 数值数据类型可以存储最多 27 个十进制数字的精度。Oracle numeric data types can store up to 27 decimal digits of precision. 当将 Oracle 数值转换为公共语言运行时数据类型,Oracle 值可能太大。When converting Oracle numeric values to common language runtime data types, the Oracle value might be too large. 相反,转换数值的公共语言运行时数据类型时向OracleNumber,数值的值可能太大或太高精度OracleNumberConversely, 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. 任何一种情况会导致 Oracle ORA 22053 溢出错误。Either of these cases will cause an Oracle ORA-22053 overflow error. 如果你的 Oracle 数据库可能包含较大值,则应使用OracleNumber数据类型。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.

构造函数

OracleNumber(OracleNumber) OracleNumber(OracleNumber) OracleNumber(OracleNumber) OracleNumber(OracleNumber)

使用提供的 OracleNumber 初始化 OracleNumber 结构的新实例。Initializes a new instance of the OracleNumber structure using the supplied OracleNumber.

OracleNumber(Decimal) OracleNumber(Decimal) OracleNumber(Decimal) OracleNumber(Decimal)

使用提供的 OracleNumber 值初始化 Decimal 结构的新实例。Initializes a new instance of the OracleNumber structure using the supplied Decimal value.

OracleNumber(Double) OracleNumber(Double) OracleNumber(Double) OracleNumber(Double)

使用所提供的双精度值初始化 OracleNumber 的新实例。Initializes a new instance of the OracleNumber using the supplied double precision value.

OracleNumber(Int32) OracleNumber(Int32) OracleNumber(Int32) OracleNumber(Int32)

使用提供的整数值初始化 OracleNumber 结构的新实例。Initializes a new instance of the OracleNumber structure using the supplied integer value.

OracleNumber(Int64) OracleNumber(Int64) OracleNumber(Int64) OracleNumber(Int64)

使用提供的长整数值初始化 OracleNumber 结构的新实例。Initializes a new instance of the OracleNumber structure using the supplied long integer value.

字段

E E E E

返回值 e-2.718。Returns the value e-2.718.

MaxPrecision MaxPrecision MaxPrecision MaxPrecision

一个常数,表示用于精度比较的最大可能值。A constant representing the largest possible value for precision comparison.

MaxScale MaxScale MaxScale MaxScale

一个常数,表示小数位数比较的最大值。A constant representing the maximum value for scale comparison.

MaxValue MaxValue MaxValue MaxValue

一个常数,表示 OracleNumber 结构的最大值。A constant representing the maximum value of an OracleNumber structure.

MinScale MinScale MinScale MinScale

一个常数,表示用于小数位数比较的最小值。A constant representing the minimum value for scale comparison.

MinusOne MinusOne MinusOne MinusOne

返回值 -1。Returns the value -1.

MinValue MinValue MinValue MinValue

一个常数,表示 OracleNumber 结构的最小值。A constant representing the minimum value for an OracleNumber structure.

Null Null Null Null

表示可分配给 Value 类实例的 OracleNumber 属性的空值。Represents a null value that can be assigned to the Value property of an instance of the OracleNumber class.

One One One One

返回值 1。Returns the value 1.

PI PI PI PI

返回 pi-3.1415926535897932384626433832795028842 值。Returns the value of pi-3.1415926535897932384626433832795028842.

Zero Zero Zero Zero

返回值 0。Returns the value 0.

属性

IsNull IsNull IsNull IsNull

指示此 Value 结构的 OracleNumber 是否为 null。Indicates whether or not the Value of this OracleNumber structure is null.

Value Value Value Value

获取 OracleNumber 结构的值。Gets the value of the OracleNumber structure. 此属性是只读的。This property is read-only.

方法

Abs(OracleNumber) Abs(OracleNumber) Abs(OracleNumber) Abs(OracleNumber)

获取 OracleNumber 参数的绝对值。Gets the absolute value of the OracleNumber parameter.

Acos(OracleNumber) Acos(OracleNumber) Acos(OracleNumber) Acos(OracleNumber)

计算 OracleNumber 的反双曲余弦值。Calculates the inverse hyperbolic cosine of an OracleNumber.

Add(OracleNumber, OracleNumber) Add(OracleNumber, OracleNumber) Add(OracleNumber, OracleNumber) Add(OracleNumber, OracleNumber)

计算两个 OracleNumber 结构的和。Calculates the sum of the two OracleNumber structures.

Asin(OracleNumber) Asin(OracleNumber) Asin(OracleNumber) Asin(OracleNumber)

计算 OracleNumber 的反双曲正弦值。Calculates the inverse hyperbolic sine of an OracleNumber.

Atan(OracleNumber) Atan(OracleNumber) Atan(OracleNumber) Atan(OracleNumber)

计算 OracleNumber 的反双曲正切值。Calculates the inverse hyperbolic tangent of an OracleNumber.

Atan2(OracleNumber, OracleNumber) Atan2(OracleNumber, OracleNumber) Atan2(OracleNumber, OracleNumber) Atan2(OracleNumber, OracleNumber)

计算两个 OracleNumber 结构的反双曲正切值。Calculates the inverse hyperbolic tangent of two OracleNumber structures.

Ceiling(OracleNumber) Ceiling(OracleNumber) Ceiling(OracleNumber) Ceiling(OracleNumber)

返回大于或等于指定 OracleNumber 结构的最小整数。Returns the smallest whole number greater than or equal to the specified OracleNumber structure.

CompareTo(Object) CompareTo(Object) CompareTo(Object) CompareTo(Object)

OracleNumber 结构的此实例与所提供的对象进行比较,并返回它们的相对值的指示值。Compares this instance of the OracleNumber structure to the supplied object and returns an indication of their relative values.

Cos(OracleNumber) Cos(OracleNumber) Cos(OracleNumber) Cos(OracleNumber)

计算 OracleNumber 的余弦值。Calculates the cosine of an OracleNumber.

Cosh(OracleNumber) Cosh(OracleNumber) Cosh(OracleNumber) Cosh(OracleNumber)

计算 OracleNumber 的双曲余弦值。Calculates the hyperbolic cosine of an OracleNumber.

Divide(OracleNumber, OracleNumber) Divide(OracleNumber, OracleNumber) Divide(OracleNumber, OracleNumber) Divide(OracleNumber, OracleNumber)

计算第一个 OracleNumber 结构除以第二个的结果。Calculates the results of dividing the first OracleNumber structure by the second.

Equals(Object) Equals(Object) Equals(Object) Equals(Object)

将提供的对象参数与 Value 对象的 OracleNumber 属性进行比较。Compares the supplied object parameter to the Value property of the OracleNumber object.

Equals(OracleNumber, OracleNumber) Equals(OracleNumber, OracleNumber) Equals(OracleNumber, OracleNumber) Equals(OracleNumber, OracleNumber)

对两个 OracleNumber 结构执行逻辑比较,以确定它们是否相等。Performs a logical comparison of the two OracleNumber structures to determine if they are equal.

Exp(OracleNumber) Exp(OracleNumber) Exp(OracleNumber) Exp(OracleNumber)

计算 e 的 OracleNumber 次幂。Calculates e raised to the power of an OracleNumber. 常数 e 等于 2.71828182845904,它是自然对数的底数。The constant e equals 2.71828182845904, the base of the natural logarithm.

Floor(OracleNumber) Floor(OracleNumber) Floor(OracleNumber) Floor(OracleNumber)

将指定 OracleNumber 数字舍入为下一个较小的整数。Rounds a specified OracleNumber number to the next lower whole number.

GetHashCode() GetHashCode() GetHashCode() GetHashCode()

返回 OracleNumber 结构的该实例的哈希代码。Returns the hash code for this instance of the OracleNumber structure.

GreaterThan(OracleNumber, OracleNumber) GreaterThan(OracleNumber, OracleNumber) GreaterThan(OracleNumber, OracleNumber) GreaterThan(OracleNumber, OracleNumber)

对两个 OracleNumber 结构执行逻辑比较,以确定第一个结构是否大于第二个结构。Performs a logical comparison of two OracleNumber structures to determine whether the first is greater than the second.

GreaterThanOrEqual(OracleNumber, OracleNumber) GreaterThanOrEqual(OracleNumber, OracleNumber) GreaterThanOrEqual(OracleNumber, OracleNumber) GreaterThanOrEqual(OracleNumber, 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) LessThan(OracleNumber, OracleNumber) LessThan(OracleNumber, OracleNumber) LessThan(OracleNumber, OracleNumber)

对两个 OracleNumber 结构执行逻辑比较,以确定第一个结构是否小于第二个结构。Performs a logical comparison of two OracleNumber structures to determine whether the first is less than the second.

LessThanOrEqual(OracleNumber, OracleNumber) LessThanOrEqual(OracleNumber, OracleNumber) LessThanOrEqual(OracleNumber, OracleNumber) LessThanOrEqual(OracleNumber, 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) Log(OracleNumber) Log(OracleNumber) Log(OracleNumber)

计算 OracleNumber 的自然对数。Calculates natural logarithm of an OracleNumber. 自然对数基于常数 e (2.71828182845904)。Natural logarithms are based on the constant e (2.71828182845904).

Log(OracleNumber, OracleNumber) Log(OracleNumber, OracleNumber) Log(OracleNumber, OracleNumber) Log(OracleNumber, OracleNumber)

OracleNumber 计算为您指定的基。Calculates an OracleNumber to the base you specify.

Log(OracleNumber, Int32) Log(OracleNumber, Int32) Log(OracleNumber, Int32) Log(OracleNumber, Int32)

OracleNumber 计算为您指定的基。Calculates an OracleNumber to the base you specify.

Log10(OracleNumber) Log10(OracleNumber) Log10(OracleNumber) Log10(OracleNumber)

计算数字以 10 为底的对数。Calculates the base 10 logarithm of a number.

Max(OracleNumber, OracleNumber) Max(OracleNumber, OracleNumber) Max(OracleNumber, OracleNumber) Max(OracleNumber, OracleNumber)

返回两个 OracleNumber 参数值中的较大者。Returns the larger of the two OracleNumber parameter values.

Min(OracleNumber, OracleNumber) Min(OracleNumber, OracleNumber) Min(OracleNumber, OracleNumber) Min(OracleNumber, OracleNumber)

返回两个 OracleNumber 参数值中的较小者。Returns the smaller of the two OracleNumber parameter values.

Modulo(OracleNumber, OracleNumber) Modulo(OracleNumber, OracleNumber) Modulo(OracleNumber, OracleNumber) Modulo(OracleNumber, OracleNumber)

计算第一个 OracleNumber 结构除以第二个结构所得结果的模数。Calculates the modulus from dividing the first OracleNumber structure by the second.

Multiply(OracleNumber, OracleNumber) Multiply(OracleNumber, OracleNumber) Multiply(OracleNumber, OracleNumber) Multiply(OracleNumber, OracleNumber)

计算两个 OracleNumber 参数的乘积。Calculates the product of the two OracleNumber parameters.

Negate(OracleNumber) Negate(OracleNumber) Negate(OracleNumber) Negate(OracleNumber)

OracleNumber 参数的值求反。Negates the value of the OracleNumber parameter.

NotEquals(OracleNumber, OracleNumber) NotEquals(OracleNumber, OracleNumber) NotEquals(OracleNumber, OracleNumber) NotEquals(OracleNumber, OracleNumber)

对两个 OracleNumber 参数执行逻辑比较,确定它们是否不相等。Performs a logical comparison of the two OracleNumber parameters to determine whether they are not equal.

Parse(String) Parse(String) Parse(String) Parse(String)

将数字的 String 表示形式转换为其等效的 OracleNumber 形式。Converts the String representation of a number to its OracleNumber equivalent.

Pow(OracleNumber, OracleNumber) Pow(OracleNumber, OracleNumber) Pow(OracleNumber, OracleNumber) Pow(OracleNumber, OracleNumber)

计算指定的 OracleNumber 结构的 n 次幂结果,其中 n 由第二个 OracleNumber 结构指定。Calculates the result of raising a specified OracleNumber structure to the power specified by a second OracleNumber structure.

Pow(OracleNumber, Int32) Pow(OracleNumber, Int32) Pow(OracleNumber, Int32) Pow(OracleNumber, Int32)

计算指定的 OracleNumber 结构的 n 次幂结果,其中 n 由 Int32 结构指定。Calculates the result of raising a specified OracleNumber structure to the power specified by an Int32 structure.

Round(OracleNumber, Int32) Round(OracleNumber, Int32) Round(OracleNumber, Int32) Round(OracleNumber, Int32)

以指定精度获取与指定 OracleNumber 结构的值最接近的数字。Gets the number nearest the specified OracleNumber structure's value with the specified precision.

Shift(OracleNumber, Int32) Shift(OracleNumber, Int32) Shift(OracleNumber, Int32) Shift(OracleNumber, Int32)

向左或向右移动指定的位数。Shifts the specified number of digits to the left or right.

Sign(OracleNumber) Sign(OracleNumber) Sign(OracleNumber) Sign(OracleNumber)

获取一个值,该值指示 OracleNumber 结构的 Value 属性的符号。Gets a value indicating the sign of an OracleNumber structure's Value property.

Sin(OracleNumber) Sin(OracleNumber) Sin(OracleNumber) Sin(OracleNumber)

计算 OracleNumber 的正弦值。Calculates the sine of an OracleNumber.

Sinh(OracleNumber) Sinh(OracleNumber) Sinh(OracleNumber) Sinh(OracleNumber)

计算 OracleNumber 的双曲正弦值。Calculates the hyperbolic sine of an OracleNumber.

Sqrt(OracleNumber) Sqrt(OracleNumber) Sqrt(OracleNumber) Sqrt(OracleNumber)

计算 OracleNumber 参数的平方根。Calculates the square root of the OracleNumber parameter.

Subtract(OracleNumber, OracleNumber) Subtract(OracleNumber, OracleNumber) Subtract(OracleNumber, OracleNumber) Subtract(OracleNumber, OracleNumber)

计算从第一个 OracleNumber 结构中减去第二个结构所得的结果。Calculates the result of subtracting the second OracleNumber structure from the first.

Tan(OracleNumber) Tan(OracleNumber) Tan(OracleNumber) Tan(OracleNumber)

计算 OracleNumber 的正切值。Calculates the tangent of an OracleNumber.

Tanh(OracleNumber) Tanh(OracleNumber) Tanh(OracleNumber) Tanh(OracleNumber)

计算 OracleNumber 的双曲正切值。Calculates the hyperbolic tangent of an OracleNumber.

ToString() ToString() ToString() ToString()

将此 OracleNumber 结构转换为 StringConverts this OracleNumber structure to String.

Truncate(OracleNumber, Int32) Truncate(OracleNumber, Int32) Truncate(OracleNumber, Int32) Truncate(OracleNumber, Int32)

将指定 OracleNumber 结构的值截断到目标位置。Truncates the specified OracleNumber structure's value to the desired position.

操作员

Addition(OracleNumber, OracleNumber) Addition(OracleNumber, OracleNumber) Addition(OracleNumber, OracleNumber) Addition(OracleNumber, OracleNumber)

计算两个 OracleNumber 结构的和。Calculates the sum of the two OracleNumber structures.

Division(OracleNumber, OracleNumber) Division(OracleNumber, OracleNumber) Division(OracleNumber, OracleNumber) Division(OracleNumber, OracleNumber)

计算第一个 OracleNumber 结构除以第二个的结果。Calculates the results of dividing the first OracleNumber structure by the second.

Equality(OracleNumber, OracleNumber) Equality(OracleNumber, OracleNumber) Equality(OracleNumber, OracleNumber) Equality(OracleNumber, OracleNumber)

对两个 OracleNumber 结构执行逻辑比较,以确定它们是否相等。Performs a logical comparison of the two OracleNumber structures to determine whether they are equal.

Explicit(String to OracleNumber) Explicit(String to OracleNumber) Explicit(String to OracleNumber) Explicit(String to OracleNumber)

将提供的 String 转换为 OracleNumber 结构。Converts the supplied String to an OracleNumber structure.

Explicit(Int64 to OracleNumber) Explicit(Int64 to OracleNumber) Explicit(Int64 to OracleNumber) Explicit(Int64 to OracleNumber)

将提供的 Int64 结构转换为 OracleNumber 结构。Converts the supplied Int64 structure to an OracleNumber structure.

Explicit(Int32 to OracleNumber) Explicit(Int32 to OracleNumber) Explicit(Int32 to OracleNumber) Explicit(Int32 to OracleNumber)

将提供的 Int32 结构转换为 OracleNumber 结构。Converts the supplied Int32 structure to an OracleNumber structure.

Explicit(Double to OracleNumber) Explicit(Double to OracleNumber) Explicit(Double to OracleNumber) Explicit(Double to OracleNumber)

将提供的 Double 结构转换为 OracleNumber 结构。Converts the supplied Double structure to an OracleNumber structure.

Explicit(OracleNumber to Int64) Explicit(OracleNumber to Int64) Explicit(OracleNumber to Int64) Explicit(OracleNumber to Int64)

OracleNumber 结构转换为 Int64Converts the OracleNumber structure to Int64.

Explicit(OracleNumber to Int32) Explicit(OracleNumber to Int32) Explicit(OracleNumber to Int32) Explicit(OracleNumber to Int32)

OracleNumber 结构转换为 Int32Converts the OracleNumber structure to Int32.

Explicit(OracleNumber to Double) Explicit(OracleNumber to Double) Explicit(OracleNumber to Double) Explicit(OracleNumber to Double)

OracleNumber 结构转换为 DoubleConverts the OracleNumber structure to Double.

Explicit(OracleNumber to Decimal) Explicit(OracleNumber to Decimal) Explicit(OracleNumber to Decimal) Explicit(OracleNumber to Decimal)

OracleNumber 结构转换为 DecimalConverts the OracleNumber structure to Decimal.

Explicit(Decimal to OracleNumber) Explicit(Decimal to OracleNumber) Explicit(Decimal to OracleNumber) Explicit(Decimal to OracleNumber)

将提供的 Decimal 结构转换为 OracleNumber 结构。Converts the supplied Decimal structure to an OracleNumber structure.

GreaterThan(OracleNumber, OracleNumber) GreaterThan(OracleNumber, OracleNumber) GreaterThan(OracleNumber, OracleNumber) GreaterThan(OracleNumber, OracleNumber)

对两个 OracleNumber 结构执行逻辑比较,以确定第一个结构是否大于第二个结构。Performs a logical comparison of two OracleNumber structures to determine whether the first is greater than the second.

GreaterThanOrEqual(OracleNumber, OracleNumber) GreaterThanOrEqual(OracleNumber, OracleNumber) GreaterThanOrEqual(OracleNumber, OracleNumber) GreaterThanOrEqual(OracleNumber, 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) Inequality(OracleNumber, OracleNumber) Inequality(OracleNumber, OracleNumber) Inequality(OracleNumber, OracleNumber)

对两个 OracleNumber 参数执行逻辑比较,以确定它们是否相等。Performs a logical comparison of the two OracleNumber parameters to determine whether they are equal.

LessThan(OracleNumber, OracleNumber) LessThan(OracleNumber, OracleNumber) LessThan(OracleNumber, OracleNumber) LessThan(OracleNumber, OracleNumber)

对两个 OracleNumber 结构执行逻辑比较,以确定第一个结构是否小于第二个结构。Performs a logical comparison of two OracleNumber structures to determine whether the first is less than the second.

LessThanOrEqual(OracleNumber, OracleNumber) LessThanOrEqual(OracleNumber, OracleNumber) LessThanOrEqual(OracleNumber, OracleNumber) LessThanOrEqual(OracleNumber, 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) Modulus(OracleNumber, OracleNumber) Modulus(OracleNumber, OracleNumber) Modulus(OracleNumber, OracleNumber)

计算用 OracleNumber 结构除以第二个 OracleNumber 结构所得的余数。Calculates the remainder left over from dividing an OracleNumber structure by a second OracleNumber structure.

Multiply(OracleNumber, OracleNumber) Multiply(OracleNumber, OracleNumber) Multiply(OracleNumber, OracleNumber) Multiply(OracleNumber, OracleNumber)

计算两个 OracleNumber 结构的乘积。Calculates the product of two OracleNumber structures.

Subtraction(OracleNumber, OracleNumber) Subtraction(OracleNumber, OracleNumber) Subtraction(OracleNumber, OracleNumber) Subtraction(OracleNumber, OracleNumber)

计算从第一个 OracleNumber 结构中减去第二个结构所得的结果。Calculates the result of subtracting the second OracleNumber structure from the first.

UnaryNegation(OracleNumber) UnaryNegation(OracleNumber) UnaryNegation(OracleNumber) UnaryNegation(OracleNumber)

OracleNumber 结构求反。Negates the OracleNumber structure.

适用于