oracle.jdbc
Class OracleTypes

java.lang.Object
  |
  +--oracle.jdbc.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
static int ARRAY
           
static int BFILE
           
static int BIGINT
           
static int BINARY
           
static int BIT
           
static int BLOB
           
static int CHAR
           
static int CLOB
           
static int CURSOR
           
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 JAVA_OBJECT
           
static int JAVA_STRUCT
           
static int LONGVARBINARY
           
static int LONGVARCHAR
           
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 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_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 ROWID
           
static int SMALLINT
           
static int STRUCT
           
static int TIME
           
static int TIMESTAMP
           
static int TIMESTAMPLTZ
           
static int TIMESTAMPNS
           
static int TIMESTAMPTZ
           
static int TINYINT
           
static int VARBINARY
           
static int VARCHAR
           
 
Constructor Summary
OracleTypes()
           
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

BIT

public static final int BIT

TINYINT

public static final int TINYINT

SMALLINT

public static final int SMALLINT

INTEGER

public static final int INTEGER

BIGINT

public static final int BIGINT

FLOAT

public static final int FLOAT

REAL

public static final int REAL

DOUBLE

public static final int DOUBLE

NUMERIC

public static final int NUMERIC

DECIMAL

public static final int DECIMAL

CHAR

public static final int CHAR

VARCHAR

public static final int VARCHAR

LONGVARCHAR

public static final int LONGVARCHAR

DATE

public static final int DATE

TIME

public static final int TIME

TIMESTAMP

public static final int TIMESTAMP

TIMESTAMPNS

public static final int TIMESTAMPNS

TIMESTAMPTZ

public static final int TIMESTAMPTZ

TIMESTAMPLTZ

public static final int TIMESTAMPLTZ

BINARY

public static final int BINARY

VARBINARY

public static final int VARBINARY

LONGVARBINARY

public static final int LONGVARBINARY

ROWID

public static final int ROWID

CURSOR

public static final int CURSOR

BLOB

public static final int BLOB

CLOB

public static final int CLOB

BFILE

public static final int BFILE

STRUCT

public static final int STRUCT

ARRAY

public static final int ARRAY

REF

public static final int REF

OPAQUE

public static final int OPAQUE

JAVA_STRUCT

public static final int JAVA_STRUCT

JAVA_OBJECT

public static final int JAVA_OBJECT

PLSQL_INDEX_TABLE

public static final int PLSQL_INDEX_TABLE

NULL

public static final int NULL

NUMBER

public static final int NUMBER
NUMBER shares same value as NUMERIC as it is synonym defined for convenience when using the oracle.sql.NUMBER type. Internally, code need only worry about NUMERIC.

RAW

public static final int RAW
RAW shares same value as BINARY as it is synonym defined for convenience when using the oracle.sql.RAW type. Internally, code need only worry about BINARY.

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.

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.
Constructor Detail

OracleTypes

public OracleTypes()