Skip navigation links

Oracle® Database JDBC Java API Reference
11g Release 2

E13995-02


oracle.jdbc
Class OracleTypes

java.lang.Object
  extended by 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()
           

 

Method Summary

 

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

BUILD_DATE

public static final java.lang.String BUILD_DATE
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

Constructor Detail

OracleTypes

public OracleTypes()

Skip navigation links

Oracle® Database JDBC Java API Reference
11g Release 2

E13995-02


Copyright © 2009, Oracle and/or its affiliates. All rights reserved.