Enum OracleCmdParamsType
Describes the type of the parameters passed to the Oracle command.
Namespace:
Assembly: Alachisoft.NCache.Runtime.dll
Syntax
public enum OracleCmdParamsTypeFields
| Name | Description |
|---|---|
| BFile | The BFILE datatype stores unstructured binary data in operating-system files outside the database. A BFILE column or attribute stores a file locator that points to an external file containing the data. The amount of BFILE data that can be stored is limited by the operating system. |
| Blob | The BLOB datatype stores unstructured binary data in the database. BLOBs can store up to 128 terabytes of binary data. |
| Byte | Allows whole numbers from 0 to 255 |
| Char | The CHAR datatype stores fixed-length character strings. String length (in bytes or characters) is between 1 and 2000 bytes. The default is 1 byte. |
| Clob | The CLOB datatypes store up to 128 terabytes of character data in the database. CLOBs store database character set data. |
| Date | The DATE datatype stores point-in-time values (dates and times) in a table. The DATE datatype stores the year (including the century), the month, the day, the hours, the minutes, and the seconds (after midnight). |
| Decimal | Decimal number datatype. |
| Double | 64-bit, double-precision floating-point number datatype. |
| Int16 | A 16-bit signed integer. |
| Int32 | A 32-bit signed integer. Allows whole numbers from -2,147,483,648 to 2,147,483,647 |
| Int64 | A 64-bit signed integer. Allows whole numbers from -2,147,483,648 to 2,147,483,647 |
| IntervalDS | Interval Day to Second literal. |
| IntervalYM | Interval Year to Month Literal. |
| Long | LONG can store variable-length character data containing up to 2 gigabytes of information. LONG data is text data that is to be appropriately converted when moving among different systems. |
| LongRaw | The LONG RAW datatypes is used for data that is not to be interpreted (not converted when moving data between different systems) by Oracle Database. These datatypes are intended for binary data or byte strings. |
| NChar | The maximum length of an NCHAR column is 2000 bytes. It can hold up to 2000 characters. The actual data is subject to the maximum byte limit of 2000. The two size constraints must be satisfied simultaneously at run time. |
| NClob | The NCLOB datatypes store up to 128 terabytes of character data in the database. NCLOBs store Unicode national character set data. |
| NVarchar2 | The maximum length of an NVARCHAR2 column is 4000 bytes. It can hold up to 4000 characters. The actual data is subject to the maximum byte limit of 4000. The two size constraints must be satisfied simultaneously at run time. |
| Raw | The RAW datatype is used for data that is not to be interpreted (not converted when moving data between different systems) by Oracle Database. These datatypes are intended for binary data or byte strings. |
| RefCursor | A REF CURSOR is a PL/SQL data type whose value is the memory address of a query work area on the database. |
| Single | Single byte character sets. |
| TimeStamp | Get the system date and time returned in a TIMESTAMP datatype. |
| TimeStampLTZ | TIMESTAMP WITH LOCAL TIME ZONE is stored in the database time zone. When a user selects the data, the value is adjusted to the user's session time zone. |
| TimeStampTZ | Get the system date and time accroding to the timezone returned in a TIMESTAMP datatype. |
| Varchar2 | The VARCHAR2 datatype stores variable-length character strings. Maximum string length (in bytes or characters) is between 1 and 4000 bytes for the VARCHAR2 column. |
| XmlType | XMLType can be used like any other user-defined type. |