All Packages  Class Hierarchy  This Package  Previous  Next  Index

Class oracle.jdbc.driver.OracleTypes 

java.lang.Object
   |
   +----oracle.jdbc.driver.OracleTypes
public class OracleTypes
extends Object

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

Variable Index

o ARRAY
o BFILE
o BIGINT
o BINARY
o BIT
o BLOB
o CHAR
o CLOB
o CURSOR
o DATE
o DECIMAL
o DOUBLE
o FIXED_CHAR
Use this type when binding to a CHAR column in the where clause of a Select statement.
o FLOAT
o INTEGER
o LONGVARBINARY
o LONGVARCHAR
o NULL
o NUMBER
o NUMERIC
o 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.
o RAW
o REAL
o REF
o ROWID
o SMALLINT
o STRUCT
o TIME
o TIMESTAMP
o TINYINT
o VARBINARY
o VARCHAR

Constructor Index

o OracleTypes()

Variables

o BIT 
 public static final int BIT
o TINYINT 
 public static final int TINYINT
o SMALLINT 
 public static final int SMALLINT
o INTEGER 
 public static final int INTEGER
o BIGINT 
 public static final int BIGINT
o FLOAT 
 public static final int FLOAT
o REAL 
 public static final int REAL
o DOUBLE 
 public static final int DOUBLE
o NUMERIC 
 public static final int NUMERIC
o DECIMAL 
 public static final int DECIMAL
o CHAR 
 public static final int CHAR
o VARCHAR 
 public static final int VARCHAR
o LONGVARCHAR 
 public static final int LONGVARCHAR
o DATE 
 public static final int DATE
o TIME 
 public static final int TIME
o TIMESTAMP 
 public static final int TIMESTAMP
o BINARY 
 public static final int BINARY
o VARBINARY 
 public static final int VARBINARY
o LONGVARBINARY 
 public static final int LONGVARBINARY
o ROWID 
 public static final int ROWID
o CURSOR 
 public static final int CURSOR
o BLOB 
 public static final int BLOB
o CLOB 
 public static final int CLOB
o BFILE 
 public static final int BFILE
o STRUCT 
 public static final int STRUCT
o ARRAY 
 public static final int ARRAY
o REF 
 public static final int REF
o NULL 
 public static final int NULL
o NUMBER 
 public static final int NUMBER
o RAW 
 public static final int RAW
o OTHER 
 public static final 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.

o FIXED_CHAR 
 public static final int FIXED_CHAR
Use this type when binding to a CHAR column in the where clause of a Select statement. A non padded comparision will be done unlike in CHAR and VARCHAR case. Not particularly needed for an insert as the database will pad it.

Constructors

o OracleTypes 
 public OracleTypes()

All Packages  Class Hierarchy  This Package  Previous  Next  Index