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	BINARY_DOUBLE
static int	BINARY_FLOAT
static int	BIT
static int	BLOB
static int	BOOLEAN The constant in the Java programming language, somtimes referred to as a type code, that identifies the generic SQL type BOOLEAN.
static java.lang.String	BUILD_DATE
static int	CHAR
static int	CLOB
static int	CURSOR
static int	DATALINK The constant in the Java programming language, somtimes 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	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 boolean	PRIVATE_TRACE
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 Deprecated. since 9.2.0. Use OracleTypes.TIMESTAMP instead.
static int	TIMESTAMPTZ
static int	TINYINT
static boolean	TRACE
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

See Also:

Constant Field Values

TINYINT

public static final int TINYINT

See Also:

Constant Field Values

SMALLINT

public static final int SMALLINT

See Also:

Constant Field Values

INTEGER

public static final int INTEGER

See Also:

Constant Field Values

BIGINT

public static final int BIGINT

See Also:

Constant Field Values

FLOAT

public static final int FLOAT

See Also:

Constant Field Values

REAL

public static final int REAL

See Also:

Constant Field Values

DOUBLE

public static final int DOUBLE

See Also:

Constant Field Values

NUMERIC

public static final int NUMERIC

See Also:

Constant Field Values

DECIMAL

public static final int DECIMAL

See Also:

Constant Field Values

CHAR

public static final int CHAR

See Also:

Constant Field Values

VARCHAR

public static final int VARCHAR

See Also:

Constant Field Values

LONGVARCHAR

public static final int LONGVARCHAR

See Also:

Constant Field Values

DATE

public static final int DATE

See Also:

Constant Field Values

TIME

public static final int TIME

See Also:

Constant Field Values

TIMESTAMP

public static final int TIMESTAMP

See Also:

Constant Field Values

TIMESTAMPNS

public static final int TIMESTAMPNS

Deprecated. since 9.2.0. Use OracleTypes.TIMESTAMP instead.

See Also:

Constant Field Values

TIMESTAMPTZ

public static final int TIMESTAMPTZ

See Also:

Constant Field Values

TIMESTAMPLTZ

public static final int TIMESTAMPLTZ

See Also:

Constant Field Values

INTERVALYM

public static final int INTERVALYM

See Also:

Constant Field Values

INTERVALDS

public static final int INTERVALDS

See Also:

Constant Field Values

BINARY

public static final int BINARY

See Also:

Constant Field Values

VARBINARY

public static final int VARBINARY

See Also:

Constant Field Values

LONGVARBINARY

public static final int LONGVARBINARY

See Also:

Constant Field Values

ROWID

public static final int ROWID

See Also:

Constant Field Values

CURSOR

public static final int CURSOR

See Also:

Constant Field Values

BLOB

public static final int BLOB

See Also:

Constant Field Values

CLOB

public static final int CLOB

See Also:

Constant Field Values

BFILE

public static final int BFILE

See Also:

Constant Field Values

STRUCT

public static final int STRUCT

See Also:

Constant Field Values

ARRAY

public static final int ARRAY

See Also:

Constant Field Values

REF

public static final int REF

See Also:

Constant Field Values

OPAQUE

public static final int OPAQUE

See Also:

Constant Field Values

JAVA_STRUCT

public static final int JAVA_STRUCT

See Also:

Constant Field Values

JAVA_OBJECT

public static final int JAVA_OBJECT

See Also:

Constant Field Values

PLSQL_INDEX_TABLE

public static final int PLSQL_INDEX_TABLE

See Also:

Constant Field Values

BINARY_FLOAT

public static final int BINARY_FLOAT

See Also:

Constant Field Values

BINARY_DOUBLE

public static final int BINARY_DOUBLE

See Also:

Constant Field Values

NULL

public static final int NULL

See Also:

Constant Field Values

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.

See Also:

Constant Field Values

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.

See Also:

Constant Field Values

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.

See Also:

Constant Field Values

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. This type is used for bind only. It cannot be used for define and registerOutParameter.

See Also:

Constant Field Values

DATALINK

public static final int DATALINK

The constant in the Java programming language, somtimes referred to as a type code, that identifies the generic SQL type DATALINK.

Since:

9.0.2

See Also:

Constant Field Values

BOOLEAN

public static final int BOOLEAN

The constant in the Java programming language, somtimes referred to as a type code, that identifies the generic SQL type BOOLEAN.

Since:

9.0.2

See Also:

Constant Field Values

TRACE

public static final boolean TRACE

See Also:

Constant Field Values

PRIVATE_TRACE

public static final boolean PRIVATE_TRACE

See Also:

Constant Field Values

BUILD_DATE

public static final java.lang.String BUILD_DATE

See Also:

Constant Field Values

Constructor Detail

OracleTypes

public OracleTypes()