| Devart.Data.Oracle Namespace : OracleDbType Enumeration (Devart.Data.Oracle) |
Specifies the data type of a field, property, OracleParameter or OracleAttribute.
| Member | Description |
|---|---|
| Array | An 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. |
| BFile | An 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 |
| Blob | A LOB data type that contains a variable-length stream of binary data. Represented as the array of |
| Boolean | A simple type representing Boolean values of true or false. Corresponds to the server PL/SQL BOOLEAN type. |
| Char | A CHAR data type that contains a fixed-length character string. Represented as the |
| Clob | An Oracle CLOB data type that contains a variable-length character data. May be represented as the OracleLob class or the |
| Cursor | An Oracle REF CURSOR. This type does not have corresponding .NET Framework type. The OracleDataReader object can be used to retrieve cursor content. |
| Date | An Oracle DATE data type. May be represented as the OracleDate class. |
| Double | An 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 |
| Float | An 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 |
| Integer | An 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 |
| IntervalDS | An 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 |
| IntervalYM | An 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 |
| Long | An Oracle LONG data type that contains a variable-length character string. May be represented as the OracleString structure or the |
| LongRaw | An Oracle LONG RAW data type that contains a variable-length stream of binary data. May be represented as the OracleBinary structure or array of |
| NChar | An Oracle NCHAR data type that contains a fixed-length national character string. May be represented as the OracleString structure or the |
| NClob | An Oracle NCLOB data type that contains a national variable-length character data. May be represented as the OracleLob class or the |
| NVarChar | An Oracle NVARCHAR data type that contains a variable-length national character string. May be represented as the OracleString structure or the |
| Number | An 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 |
| Object | One 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. |
| Ref | An 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. |
| Raw | An 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 |
| RowId | The string representation of an Oracle ROWID data type. May be represented as the OracleString structure or the |
| Table | An 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. |
| TimeStamp | A TIMESTAMP data type that contains date and time, including seconds. Represented as the |
| TimeStampLTZ | An 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 |
| TimeStampTZ | An Oracle TIMESTAMP WITH TIMEZONE data type that contains date, time, and a specified time zone. May be represented as the OracleTimeStamp structure or the |
| VarChar | A VARCHAR data type that contains a variable-length character string. Represented as the |
| Xml | An Oracle XMLType type that contains XML data. May be represented as the OracleXml object. |
| AnyData | An 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. |
This table shows mappings between OracleDbType values, Oracle data types, Microsoft .NET Framework types.
© 2002 - 2013 Devart. All Rights Reserved.