Package oracle.jdbc

Class OracleTypes

  • public abstract class OracleTypes
extends java.lang.Object
    Oracle types.

    This interface defines constants that are used to identify SQL types. The actual type constant values are equivalent to those in XOPEN.

    • Field Summary

      Fields 
      Modifier and Type Field Description
      static int ARRAY  
      static int BFILE  
      static int BIGINT  
      static int BINARY  
      static int BINARY_DOUBLE  
      static int BINARY_FLOAT  
      static int BIT  
      static int BLOB  
      static int BOOLEAN
      The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BOOLEAN.
      static int CHAR  
      static int CLOB  
      static int CURSOR  
      static int DATALINK
      The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DATALINK.
      static int DATE  
      static int DECIMAL  
      static int DOUBLE  
      static int FIXED_CHAR
      Use this type when binding to a CHAR column in the where clause of a Select statement.
      static int FLOAT  
      static int INTEGER  
      static int INTERVALDS  
      static int INTERVALYM  
      static int JAVA_OBJECT  
      static int JAVA_STRUCT  
      static int JSON  
      static int LONGNVARCHAR  
      static int LONGVARBINARY  
      static int LONGVARCHAR  
      static int NCHAR  
      static int NCLOB  
      static int NULL  
      static int NUMBER
      NUMBER shares same value as NUMERIC as it is synonym defined for convenience when using the oracle.sql.NUMBER type.
      static int NUMERIC  
      static int NVARCHAR  
      static int OPAQUE  
      static int OTHER
      OTHER indicates that the SQL type is database specific and gets mapped to a Java object which can be accessed via getObject and setObject.
      static int PLSQL_BOOLEAN
      PLSQL_BOOLEAN binds BOOLEAN type for input/output parameters when executing a PLSQL function/procedure.
      static int PLSQL_INDEX_TABLE  
      static int RAW
      RAW shares same value as BINARY as it is synonym defined for convenience when using the oracle.sql.RAW type.
      static int REAL  
      static int REF  
      static int REF_CURSOR  
      static int ROWID  
      static int SMALLINT  
      static int SQLXML  
      static int STRUCT  
      static int TIME  
      static int TIMESTAMP  
      static int TIMESTAMPLTZ  
      static int TIMESTAMPNS
      Deprecated.
      since 9.2.0.
      static int TIMESTAMPTZ  
      static int TINYINT  
      static int UNSPECIFIED  
      static int VARBINARY  
      static int VARCHAR  

    • Constructor Summary

      Constructors 
      Constructor Description
      OracleTypes()  

    • Method Summary

      • Methods inherited from class java.lang.Object

        clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait