Enum OracleCmdParamsType
- java.lang.Object
-
- java.lang.Enum<OracleCmdParamsType>
-
- com.alachisoft.ncache.runtime.dependencies.OracleCmdParamsType
-
- All Implemented Interfaces:
java.io.Serializable
,java.lang.Comparable<OracleCmdParamsType>
public enum OracleCmdParamsType extends java.lang.Enum<OracleCmdParamsType>
Describes the type of the parameters passed to the Oracle command.
-
-
Enum Constant Summary
Enum Constants Enum Constant Description BFile
The BFILE datatype stores unstructured binary data in operating-system files outside the database.Blob
The BLOB datatype stores unstructured binary data in the database.Byte
Allows whole numbers from 0 to 255Char
The CHAR datatype stores fixed-length character strings.Clob
The CLOB datatypes store up to 128 terabytes of character data in the database.Date
The Date datatype stores point-in-time values (dates and times) in a table.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.Int64
A 64-bit signed integer.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.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.NChar
The maximum length of an NCHAR column is 2000 bytes.NClob
The NCLOB datatypes store up to 128 terabytes of character data in the database.NVarchar2
The maximum length of an NVARCHAR2 column is 4000 bytes.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.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.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.XmlType
XMLType can be used like any other user-defined type.
-
Method Summary
All Methods Static Methods Instance Methods Concrete Methods Modifier and Type Method Description static OracleCmdParamsType
getOracleCmdParamsType(int value)
retreives the enum constant of the specified value, if exists.int
getValue()
Order is important in enums.By using getValue() method, each enum constant index can be found, just like array index.static OracleCmdParamsType
valueOf(java.lang.String name)
Returns the enum constant of this type with the specified name.static OracleCmdParamsType[]
values()
Returns an array containing the constants of this enum type, in the order they are declared.
-
-
-
Enum Constant Detail
-
BFile
public static final OracleCmdParamsType 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
public static final OracleCmdParamsType Blob
The BLOB datatype stores unstructured binary data in the database. BLOBs can store up to 128 terabytes of binary data.
-
Byte
public static final OracleCmdParamsType Byte
Allows whole numbers from 0 to 255
-
Char
public static final OracleCmdParamsType 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
public static final OracleCmdParamsType Clob
The CLOB datatypes store up to 128 terabytes of character data in the database. CLOBs store database character set data.
-
Date
public static final OracleCmdParamsType 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
public static final OracleCmdParamsType Decimal
Decimal number datatype.
-
Double
public static final OracleCmdParamsType Double
64-bit, double-precision floating-point number datatype.
-
Int16
public static final OracleCmdParamsType Int16
A 16-bit signed integer.
-
Int32
public static final OracleCmdParamsType Int32
A 32-bit signed integer.
-
Int64
public static final OracleCmdParamsType Int64
A 64-bit signed integer.
-
IntervalDS
public static final OracleCmdParamsType IntervalDS
Interval Day to Second literal.
-
IntervalYM
public static final OracleCmdParamsType IntervalYM
Interval Year to Month Literal.
-
Long
public static final OracleCmdParamsType 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
public static final OracleCmdParamsType 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
public static final OracleCmdParamsType 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
public static final OracleCmdParamsType NClob
The NCLOB datatypes store up to 128 terabytes of character data in the database. NCLOBs store Unicode national character set data.
-
NVarchar2
public static final OracleCmdParamsType 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
public static final OracleCmdParamsType 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
public static final OracleCmdParamsType 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
public static final OracleCmdParamsType Single
Single byte character sets.
-
TimeStamp
public static final OracleCmdParamsType TimeStamp
Get the system date and time returned in a Timestamp datatype.
-
TimeStampLTZ
public static final OracleCmdParamsType 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
public static final OracleCmdParamsType TimeStampTZ
Get the system date and time accroding to the timezone returned in a Timestamp datatype.
-
Varchar2
public static final OracleCmdParamsType 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
public static final OracleCmdParamsType XmlType
XMLType can be used like any other user-defined type.
-
-
Method Detail
-
values
public static OracleCmdParamsType[] values()
Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:for (OracleCmdParamsType c : OracleCmdParamsType.values()) System.out.println(c);
- Returns:
- an array containing the constants of this enum type, in the order they are declared
-
valueOf
public static OracleCmdParamsType valueOf(java.lang.String name)
Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)- Parameters:
name
- the name of the enum constant to be returned.- Returns:
- the enum constant with the specified name
- Throws:
java.lang.IllegalArgumentException
- if this enum type has no constant with the specified namejava.lang.NullPointerException
- if the argument is null
-
getOracleCmdParamsType
public static OracleCmdParamsType getOracleCmdParamsType(int value) throws java.lang.IllegalArgumentException
retreives the enum constant of the specified value, if exists.- Parameters:
value
- enum constant index- Returns:
- enum constant
- Throws:
java.lang.IllegalArgumentException
-
getValue
public int getValue()
Order is important in enums.By using getValue() method, each enum constant index can be found, just like array index.- Returns:
- enum constant index
-
-