OracleType 枚举

定义

指定字段或属性的数据类型,以用于 OracleParameterSpecifies the data type of a field or property for use in an OracleParameter.

public enum class OracleType
public enum OracleType
type OracleType = 
Public Enum OracleType
继承
OracleType

字段

BFile 1

Oracle BFILE 数据类型,它包含存储在外部文件中的最大为 4 GB 的二进制数据的引用。An Oracle BFILE data type that contains a reference to binary data with a maximum size of 4 gigabytes that is stored in an external file. 使用具有 OracleBFile 属性的 OracleClient Value 数据类型。Use the OracleClient OracleBFile data type with the Value property.

Blob 2

包含二进制数据的 Oracle BLOB 数据类型,其最大大小为 4 GB。An Oracle BLOB data type that contains binary data with a maximum size of 4 gigabytes. 使用 OracleLob 中的 OracleClient Value 数据类型。Use the OracleClient OracleLob data type in Value.

Byte 23

整型,表示值介于 0 到 255 之间的无符号 8 位整数。An integral type representing unsigned 8-bit integers with values between 0 and 255. 这不是本机的 Oracle 数据类型,但是提供此类型以提高绑定输入参数时的性能。This is not a native Oracle data type, but is provided to improve performance when binding input parameters. Byte 中使用 .NET Framework Value 数据类型。Use the .NET Framework Byte data type in Value.

Char 3

Oracle CHAR 数据类型,它包含最大为 2,000 字节的定长字符串。An Oracle CHAR data type that contains a fixed-length character string with a maximum size of 2,000 bytes. String 中使用 .NET Framework OracleString 或 OracleClient Value 数据类型。Use the .NET Framework String or OracleClient OracleString data type in Value.

Clob 4

包含字符数据的 Oracle CLOB 数据类型,根据服务器的默认字符集,其最大大小为 4 GB。An Oracle CLOB data type that contains character data, based on the default character set on the server, with a maximum size of 4 gigabytes. 使用 OracleLob 中的 OracleClient Value 数据类型。Use the OracleClient OracleLob data type in Value.

Cursor 5

Oracle REF CURSORAn Oracle REF CURSOR. OracleDataReader 对象不可用。The OracleDataReader object is not available.

DateTime 6

Oracle DATE 数据类型,它包含固定长度的日期和时间表示形式,范围从公元前 4712 年 1 月 1 日An Oracle DATE data type that contains a fixed-length representation of a date and time, ranging from January 1, 4712 B.C. 到公元 4712 年 12 月 31 日。to December 31, A.D. 默认格式为 yy-mmm-dd。4712, with the default format dd-mmm-yy. 对于公元日期,For A.D. DATE 将映射到 DateTimedates, DATE maps to DateTime. 要绑定公元前的日期,To bind B.C. 请分别对输入和输出参数使用 String 参数和 Oracle TO_DATE 或 TO_CHAR 转换函数。dates, use a String parameter and the Oracle TO_DATE or TO_CHAR conversion functions for input and output parameters respectively. DateTime 中使用 .NET Framework OracleDateTime 或 OracleClient Value 数据类型。Use the .NET Framework DateTime or OracleClient OracleDateTime data type in Value.

Double 30

一个双精度浮点值。A double-precision floating-point value. 这不是本机的 Oracle 数据类型,但是提供此类型以提高绑定输入参数时的性能。This is not a native Oracle data type, but is provided to improve performance when binding input parameters. 有关从 Oracle 数值转换为公共语言运行时 (CLR) 数据类型的信息,请参见 OracleNumberFor information about conversion of Oracle numeric values to common language runtime (CLR) data types, see OracleNumber. Double 中使用 .NET Framework OracleNumber 或 OracleClient Value 数据类型。Use the .NET Framework Double or OracleClient OracleNumber data type in Value.

Float 29

单精度浮点值。A single-precision floating-point value. 这不是本机的 Oracle 数据类型,但是提供此类型以提高绑定输入参数时的性能。This is not a native Oracle data type, but is provided to improve performance when binding input parameters. 有关从 Oracle 数值转换到公共语言运行时数据类型的信息,请参见 OracleNumberFor information about conversion of Oracle numeric values to common language runtime data types, see OracleNumber. Single 中使用 .NET Framework OracleNumber 或 OracleClient Value 数据类型。Use the .NET Framework Single or OracleClient OracleNumber data type in Value.

Int16 27

整型,表示值介于 -32768 到 32767 之间的有符号 16 位整数。An integral type representing signed 16-bit integers with values between -32768 and 32767. 这不是本机的 Oracle 数据类型,但是提供此类型以提高绑定输入参数时的性能。This is not a native Oracle data type, but is provided to improve performance when binding input parameters. 有关从 Oracle 数值转换为公共语言运行时 (CLR) 数据类型的信息,请参见 OracleNumberFor information about conversion of Oracle numeric values to common language runtime (CLR) data types, see OracleNumber. Int16 中使用 .NET Framework OracleNumber 或 OracleClient Value 数据类型。Use the .NET Framework Int16 or OracleClient OracleNumber data type in Value.

Int32 28

整型,表示值介于 -2147483648 到 2147483647 之间的 32 位有符号整数。An integral type representing signed 32-bit integers with values between -2147483648 and 2147483647. 这不是本机 Oracle 数据类型,但是提供此类型是为了提高绑定输入参数时的性能。This is not a native Oracle data type, but is provided for performance when binding input parameters. 有关从 Oracle 数值转换到公共语言运行时数据类型的信息,请参见 OracleNumberFor information about conversion of Oracle numeric values to common language runtime data types, see OracleNumber. Int32 中使用 .NET Framework OracleNumber 或 OracleClient Value 数据类型。Use the .NET Framework Int32 or OracleClient OracleNumber data type in Value.

IntervalDayToSecond 7

Oracle INTERVAL DAY TO SECOND 数据类型(Oracle 9i 或更高版本),它包含以天、小时、分钟和秒为计量单位的时间间隔,大小固定,为 11 字节。An Oracle INTERVAL DAY TO SECOND data type (Oracle 9i or later) that contains an interval of time in days, hours, minutes, and seconds, and has a fixed size of 11 bytes. TimeSpan 中使用 .NET Framework OracleTimeSpan 或 OracleClient Value 数据类型。Use the .NET Framework TimeSpan or OracleClient OracleTimeSpan data type in Value.

IntervalYearToMonth 8

Oracle INTERVAL YEAR TO MONTH 数据类型(Oracle 9i 或更高版本),它包含以年和月为单位的时间间隔,大小固定,为 5 字节。An Oracle INTERVAL YEAR TO MONTH data type (Oracle 9i or later) that contains an interval of time in years and months, and has a fixed size of 5 bytes. Int32 中使用 .NET Framework OracleMonthSpan 或 OracleClient Value 数据类型。Use the .NET Framework Int32 or OracleClient OracleMonthSpan data type in Value.

LongRaw 9

包含变长二进制数据的 Oracle LONGRAW 数据类型,其最大大小为 2 GB。An Oracle LONGRAW data type that contains variable-length binary data with a maximum size of 2 gigabytes. Byte[] 中使用 .NET Framework OracleBinary 或 OracleClient Value 数据类型。Use the .NET Framework Byte[] or OracleClient OracleBinary data type in Value.

更新带有 LONG RAW 数据类型的列时,在列中输入值 null 会引发异常。When you update a column with the LONG RAW data type, an exception is thrown when you enter a value of null in the column. Oracle LONG RAW 数据类型是 Oracle 版本 8.0 中已弃用的类型。The Oracle LONG RAW data type is a deprecated type in Oracle version 8.0. 要避免此错误,请使用 BLOB 数据类型而不是 LONG RAWTo avoid this error, use the BLOB data type instead of LONG RAW.

LongVarChar 10

Oracle LONG 数据类型,它包含最大为 2 GB 的变长字符串。An Oracle LONG data type that contains a variable-length character string with a maximum size of 2 gigabytes. String 中使用 .NET Framework OracleString 或 OracleClient Value 数据类型。Use the .NET Framework String or OracleClient OracleString data type in Value.

NChar 11

Oracle NCHAR 数据类型,它包含要存储在数据库的区域字符集中的定长字符串,存储在数据库中时最大大小为 2,000 字节(不是字符)。An Oracle NCHAR data type that contains fixed-length character string to be stored in the national character set of the database, with a maximum size of 2,000 bytes (not characters) when stored in the database. 值的大小取决于数据库的区域字符集。The size of the value depends on the national character set of the database. 有关更多信息,请参见 Oracle 文档。See your Oracle documentation for more information. String 中使用 .NET Framework OracleString 或 OracleClient Value 数据类型。Use the .NET Framework String or OracleClient OracleString data type in Value.

NClob 12

Oracle NCLOB 数据类型,它包含要存储在数据库的区域字符集中的字符数据,存储在数据库中时最大大小为 4 GB(不是字符)。An Oracle NCLOB data type that contains character data to be stored in the national character set of the database, with a maximum size of 4 gigabytes (not characters) when stored in the database. 值的大小取决于数据库的区域字符集。The size of the value depends on the national character set of the database. 有关更多信息,请参见 Oracle 文档。See your Oracle documentation for more information. String 中使用 .NET Framework OracleString 或 OracleClient Value 数据类型。Use the .NET Framework String or OracleClient OracleString data type in Value.

Number 13

Oracle NUMBER 数据类型,它包含最大精度和小数位数为 38 的变长数值数据。An Oracle NUMBER data type that contains variable-length numeric data with a maximum precision and scale of 38. 它映射到 DecimalThis maps to Decimal. 若要绑定超出 MaxValue 可包含的大小的 Oracle NUMBER,请使用 OracleNumber 数据类型,或为输入参数和输出参数分别使用 String 参数和 Oracle TO_NUMBER 或 TO_CHAR 转换函数。To bind an Oracle NUMBER that exceeds what MaxValue can contain, either use an OracleNumber data type, or use a String parameter and the Oracle TO_NUMBER or TO_CHAR conversion functions for input and output parameters respectively. Decimal 中使用 .NET Framework OracleNumber 或 OracleClient Value 数据类型。Use the .NET Framework Decimal or OracleClient OracleNumber data type in Value.

NVarChar 14

Oracle NVARCHAR2 数据类型,它包含数据库的区域字符集中存储的变长字符串,存储在数据库中时最大大小为 4,000 字节(不是字符)。An Oracle NVARCHAR2 data type that contains a variable-length character string stored in the national character set of the database, with a maximum size of 4,000 bytes (not characters) when stored in the database. 值的大小取决于数据库的区域字符集。The size of the value depends on the national character set of the database. 有关更多信息,请参见 Oracle 文档。See your Oracle documentation for more information. String 中使用 .NET Framework OracleString 或 OracleClient Value 数据类型。Use the .NET Framework String or OracleClient OracleString data type in Value.

Raw 15

Oracle RAW 数据类型,它包含最大为 2,000 字节的变长二进制数据。An Oracle RAW data type that contains variable-length binary data with a maximum size of 2,000 bytes. Byte[] 中使用 .NET Framework OracleBinary 或 OracleClient Value 数据类型。Use the .NET Framework Byte[] or OracleClient OracleBinary data type in Value.

RowId 16

Oracle ROWID 数据类型的 base64 字符串表示形式。The base64 string representation of an Oracle ROWID data type. String 中使用 .NET Framework OracleString 或 OracleClient Value 数据类型。Use the .NET Framework String or OracleClient OracleString data type in Value.

SByte 26

整型,表示值介于 -128 到 127 之间的有符号 8 位整数。An integral type representing signed 8 bit integers with values between -128 and 127. 这不是本机的 Oracle 数据类型,但是提供此类型以提高绑定输入参数时的性能。This is not a native Oracle data type, but is provided to improve performance when binding input parameters. SByte 中使用 .NET Framework Value 数据类型。Use the .NET Framework SByte data type in Value.

Timestamp 18

Oracle TIMESTAMP(Oracle 9i 或更高版本),它包含日期和时间(包括秒),大小范围从 7 字节到 11 字节。An Oracle TIMESTAMP (Oracle 9i or later) that contains date and time (including seconds), and ranges in size from 7 to 11 bytes. DateTime 中使用 .NET Framework OracleDateTime 或 OracleClient Value 数据类型。Use the .NET Framework DateTime or OracleClient OracleDateTime data type in Value.

TimestampLocal 19

Oracle TIMESTAMP WITH LOCAL TIMEZONE(Oracle 9i 或更高版本),它包含日期、时间和对原始时区的引用,大小范围从 7 字节到 11 字节。An Oracle TIMESTAMP WITH LOCAL TIMEZONE (Oracle 9i or later) that contains date, time, and a reference to the original time zone, and ranges in size from 7 to 11 bytes. DateTime 中使用 .NET Framework OracleDateTime 或 OracleClient Value 数据类型。Use the .NET Framework DateTime or OracleClient OracleDateTime data type in Value.

TimestampWithTZ 20

Oracle TIMESTAMP WITH TIMEZONE(Oracle 9i 或更高版本),它包含日期、时间和指定时区,大小固定,为 13 字节。An Oracle TIMESTAMP WITH TIMEZONE (Oracle 9i or later) that contains date, time, and a specified time zone, and has a fixed size of 13 bytes. DateTime 中使用 .NET Framework OracleDateTime 或 OracleClient Value 数据类型。Use the .NET Framework DateTime or OracleClient OracleDateTime data type in Value.

UInt16 24

整型,表示值介于 0 到 65535 之间的 16 位无符号整数。An integral type representing unsigned 16-bit integers with values between 0 and 65535. 这不是本机的 Oracle 数据类型,但是提供此类型以提高绑定输入参数时的性能。This is not a native Oracle data type, but is provided to improve performance when binding input parameters. 有关从 Oracle 数值转换为公共语言运行时 (CLR) 数据类型的信息,请参见 OracleNumberFor information about conversion of Oracle numeric values to common language runtime (CLR) data types, see OracleNumber. UInt16 中使用 .NET Framework OracleNumber 或 OracleClient Value 数据类型。Use the .NET Framework UInt16 or OracleClient OracleNumber data type in Value.

UInt32 25

整型,表示值介于 0 到 4294967295 之间的 32 位无符号整数。An integral type representing unsigned 32-bit integers with values between 0 and 4294967295. 这不是本机的 Oracle 数据类型,但是提供此类型以提高绑定输入参数时的性能。This is not a native Oracle data type, but is provided to improve performance when binding input parameters. 有关从 Oracle 数值转换为公共语言运行时 (CLR) 数据类型的信息,请参见 OracleNumberFor information about conversion of Oracle numeric values to common language runtime (CLR) data types, see OracleNumber. UInt32 中使用 .NET Framework OracleNumber 或 OracleClient Value 数据类型。Use the .NET Framework UInt32 or OracleClient OracleNumber data type in Value.

VarChar 22

Oracle VARCHAR2 数据类型,它包含最大为 4,000 字节的变长字符串。An Oracle VARCHAR2 data type that contains a variable-length character string with a maximum size of 4,000 bytes. String 中使用 .NET Framework OracleString 或 OracleClient Value 数据类型。Use the .NET Framework String or OracleClient OracleString data type in Value.

适用于