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 數值轉換成 common language runtime 資料類型時, Oracle 值可能太大。When converting Oracle numeric values to common language runtime data types, the Oracle value might be too large. 相反地, 將 common language runtime 資料類型的數值轉換成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 TNSNAMES.ORA-22053 溢位錯誤。Either of these cases will cause an Oracle ORA-22053 overflow error. 如果您的OracleNumber Oracle 資料庫可能包含大數值, 您應該使用資料類型。If your Oracle database might contain large values, you should use the OracleNumber data type. 然後, 您可以明確地轉換為 common language runtime 資料類型, 並攔截或處理任何錯誤。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 屬性的 null 值。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 的 Inverse Hyperbolic Cosine (反雙曲線餘弦)。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 的反雙曲線正弦 (Inverse Hyperbolic Sine)。Calculates the inverse hyperbolic sine of an OracleNumber.

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

計算 OracleNumber 的反雙曲線正切 (Inverse Hyperbolic Tangent)。Calculates the inverse hyperbolic tangent of an OracleNumber.

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

計算兩個 OracleNumber 結構的反雙曲線正切 (Inverse Hyperbolic Tangent)。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 的餘弦函數 (Cosine)。Calculates the cosine of an OracleNumber.

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

計算 OracleNumber 的 Hyperbolic Cosine (雙曲線餘弦)。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)

計算 OracleNumber 的 e 乘冪數。Calculates e raised to the power of an OracleNumber. 常數 e 等於 2.71828182845904,即自然對數 (Natural Logarithm) 的基礎。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)

對您指定的基礎計算 OracleNumberCalculates an OracleNumber to the base you specify.

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

對您指定的基礎計算 OracleNumberCalculates 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 結構自乘到第二個 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 結構自乘到 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)

將指定位數移位 (Shift) 到左邊或右邊。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 的雙曲線正弦 (Hyperbolic Sine)。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 的雙曲線正切 (Hyperbolic Tangent)。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.

適用於