GetDecimalRetainTrailingZeros

This property specifies whether to retain trailing zeros from an Oracle NUMBER in a .NET Decimal.

Declaration

// C#
public static bool GetDecimalRetainTrailingZeros { get; set; }

Property Type

System.Boolean

Remarks

Starting with ODP.NET 19.11, Oracle NUMBER column values retrieved as .NET Decimals retain a trailing zero if the number of digits on the right hand side of the decimal point is odd in number when this property is set to true.

The default value is false.

This property can be used whenever retrieving data into a .NET Decimal, including the following scenarios:

OracleDataReader.GetDecimal();
OracleDecimal.Value
Parameter output value of type Decimal
JSON data with Decimal in it
UDT with Decimal attribute