See Also

Devart.Data.Oracle Namespace

Language

Visual Basic

C#

Show All

See AlsoLanguagesDevart.Data.OracleSend comments on this topic.

OracleDbType Enumeration

Devart.Data.Oracle Namespace : OracleDbType Enumeration (Devart.Data.Oracle)

Specifies the data type of a field, property, OracleParameter or OracleAttribute.

Members

MemberDescription
ArrayAn Oracle VARRAY data type representing a variable-length array. May be represented as the OracleArray class. This type does not have corresponding .NET Framework type.
BFileAn Oracle BFILE data type that contains a reference to binary data stored in an external file. May be represented as the OracleBFile class or array of Byte.
BlobA LOB data type that contains a variable-length stream of binary data. Represented as the array of Byte.
BooleanA simple type representing Boolean values of true or false. Corresponds to the server PL/SQL BOOLEAN type.
CharA CHAR data type that contains a fixed-length character string. Represented as the String.
ClobAn Oracle CLOB data type that contains a variable-length character data. May be represented as the OracleLob class or the String.
CursorAn Oracle REF CURSOR. This type does not have corresponding .NET Framework type. The OracleDataReader object can be used to retrieve cursor content.
DateAn Oracle DATE data type. May be represented as the OracleDate class.
DoubleAn Oracle NUMBER(p, s) [p >= 10 or s > 0] data type and BINARY_DOUBLE number data type of Oracle 10g that contains a double-precision floating-point value. A floating point type representing values ranging from approximately -1.79 x 10(308) to 1.79 x 10(308) with a precision of 15-16 digits. May be represented as the OracleNumber structure or the Double.
FloatAn Oracle 10g BINARY_FLOAT number data type that contains a single-precision floating-point value. A floating point type representing values ranging from approximately -3.4 x 10(38) to 3.4 x 10(38). May be represented as the Single.
IntegerAn Oracle NUMBER(p) [p < 10] data type that contains a signed 32-bit integers with values between -2147483648 and 2147483647. May be represented as the OracleNumber structure or the Int32.
IntervalDSAn Oracle INTERVAL DAY TO SECOND data type that contains an interval of time in days, hours, minutes, and seconds. May be represented as the OracleIntervalDS structure or the TimeSpan.
IntervalYMAn Oracle INTERVAL YEAR TO MONTH data type that contains an interval of time in years and months. May be represented as the OracleIntervalYM structure or the Int64.
LongAn Oracle LONG data type that contains a variable-length character string. May be represented as the OracleString structure or the String.
LongRawAn Oracle LONG RAW data type that contains a variable-length stream of binary data. May be represented as the OracleBinary structure or array of Byte.
NCharAn Oracle NCHAR data type that contains a fixed-length national character string. May be represented as the OracleString structure or the String.
NClobAn Oracle NCLOB data type that contains a national variable-length character data. May be represented as the OracleLob class or the String.
NVarCharAn Oracle NVARCHAR data type that contains a variable-length national character string. May be represented as the OracleString structure or the String.
NumberAn Oracle NUMBER data type that contains variable-length numeric data with a maximum precision and scale of 38. May be represented as the OracleNumber structure or the Decimal.
ObjectOne of the Oracle object types defined by the user. May be represented as the OracleObject class. This type does not have corresponding .NET Framework type.
RefAn Oracle REF data type that contains a reference to the object. May be represented as the OracleRef class. This type does not have corresponding .NET Framework type.
RawAn Oracle RAW data type that contains a fixed-length stream of binary data ranging between 1 and 4,000 bytes. May be represented as the OracleBinary structure or array of Byte.
RowIdThe string representation of an Oracle ROWID data type. May be represented as the OracleString structure or the String.
TableAn Oracle NESTED TABLE data type, an unordered set of data elements, all of the same type. May be represented as the OracleTable class. This type does not have corresponding .NET Framework type.
TimeStampA TIMESTAMP data type that contains date and time, including seconds. Represented as the DateTime.
TimeStampLTZAn Oracle TIMESTAMP WITH LOCAL TIMEZONE data type that contains date, time, and a reference to the original time zone. May be represented as the OracleTimeStamp structure or the DateTime.
TimeStampTZAn Oracle TIMESTAMP WITH TIMEZONE data type that contains date, time, and a specified time zone. May be represented as the OracleTimeStamp structure or the DateTime.
VarCharA VARCHAR data type that contains a variable-length character string. Represented as the String.
XmlAn Oracle XMLType type that contains XML data. May be represented as the OracleXml object.
AnyDataAn ANYDATA TYPE contains an instance of a given type, plus a description of the type. In this sense, an ANYDATA is self-describing. An ANYDATA can be persistently stored in the database.

Remarks

This table shows mappings between OracleDbType values, Oracle data types, Microsoft .NET Framework types.

See Also

Devart.Data.Oracle Namespace

 

 


© 2002 - 2013 Devart. All Rights Reserved.