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.
Methods inherited from class java.lang.Object |
equals,
getClass,
hashCode,
notify,
notifyAll,
toString,
wait,
wait,
wait |
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.
OracleTypes
public OracleTypes()