Enum 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 255
      Char
      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.
      • Methods inherited from class java.lang.Enum

        clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf
      • Methods inherited from class java.lang.Object

        getClass, notify, notifyAll, wait, wait, wait
    • 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.
      • 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).
      • Double

        public static final OracleCmdParamsType Double
        64-bit, double-precision floating-point number datatype.
      • 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.
      • 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 name
        java.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