Oracle Database JDBC开发人员指南和参考
| SQL Data Types | JDBC Type Codes | Standard Java Types | Oracle Extension Java Types |
|---|
| CHAR
| java.sql.Types.CHAR
| java.lang.String
| oracle.sql.CHAR
|
| VARCHAR2
| java.sql.Types.VARCHAR
| java.lang.String
| oracle.sql.CHAR
|
| LONG
| java.sql.Types.LONGVARCHAR
| java.lang.String
| oracle.sql.CHAR
|
| NUMBER
| java.sql.Types.NUMERIC
| java.math.BigDecimal
| oracle.sql.NUMBER
|
| NUMBER
| java.sql.Types.DECIMAL
| java.math.BigDecimal
| oracle.sql.NUMBER
|
| NUMBER
| java.sql.Types.BIT
| boolean
| oracle.sql.NUMBER
|
| NUMBER
| java.sql.Types.TINYINT
| byte
| oracle.sql.NUMBER
|
| NUMBER
| java.sql.Types.SMALLINT
| short
| oracle.sql.NUMBER
|
| NUMBER
| java.sql.Types.INTEGER
| int
| oracle.sql.NUMBER
|
| NUMBER
| java.sql.Types.BIGINT
| long
| oracle.sql.NUMBER
|
| NUMBER
| java.sql.Types.REAL
| float
| oracle.sql.NUMBER
|
| NUMBER
| java.sql.Types.FLOAT
| double
| oracle.sql.NUMBER
|
| NUMBER
| java.sql.Types.DOUBLE
| double
| oracle.sql.NUMBER
|
| RAW
| java.sql.Types.BINARY
| byte[]
| oracle.sql.RAW
|
| RAW
| java.sql.Types.VARBINARY
| byte[]
| oracle.sql.RAW
|
| LONGRAW
| java.sql.Types.LONGVARBINARY
| byte[]
| oracle.sql.RAW
|
| DATE
| java.sql.Types.DATE
| java.sql.Date
| oracle.sql.DATE
|
| DATE
| java.sql.Types.TIME
| java.sql.Time
| oracle.sql.DATE
|
| TIMESTAMP
| java.sql.Types.TIMESTAMP
| javal.sql.Timestamp
| oracle.sql.TIMESTAMP
|
| BLOB
| java.sql.Types.BLOB
| java.sql.Blob
| oracle.jdbc.OracleBlobFoot 1
|
| CLOB
| java.sql.Types.CLOB
| java.sql.Clob
| oracle.jdbc.OracleClobFoot 2
|
| user-defined object | java.sql.Types.STRUCT
| java.sql.Struct
| oracle.jdbc.OracleStructFoot 3
|
| user-defined reference | java.sql.Types.REF
| java.sql.Ref
| oracle.jdbc.OracleRefFoot 4
|
| user-defined collection | java.sql.Types.ARRAY
| java.sql.Array
| oracle.jdbc.OracleArrayFoot 5
|
| ROWID
| java.sql.Types.ROWID
| java.sql.RowId
| oracle.sql.ROWID
|
| NCLOB
| java.sql.Types.NCLOB
| java.sql.NClob
| oracle.sql.NCLOB
|
| NCHAR
| java.sql.Types.NCHAR
| java.lang.String
| oracle.sql.CHAR
|
| BFILE
| oracle.jdbc.OracleTypes.BFILE
(ORACLE EXTENSION) | NA | oracle.sql.BFILE
|
| REF CURSOR
| oracle.jdbc.OracleTypes.CURSOR
(ORACLE EXTENSION) | java.sql.ResultSet
| oracle.jdbc.OracleResultSet
|
| TIMESTAMP
| oracle.jdbc.OracleTypes.TIMESTAMP
(ORACLE EXTENSION) | java.sql.Timestamp
| oracle.sql.TIMESTAMP
|
| TIMESTAMP WITH TIME ZONE
| oracle.jdbc.OracleTypes.TIMESTAMPTZ
(ORACLE EXTENSION) | java.sql.Timestamp
| oracle.sql.TIMESTAMPTZ
|
| TIMESTAMP WITH LOCAL TIME ZONE
| oracle.jdbc.OracleTypes.TIMESTAMPLTZ
(ORACLE EXTENSION) | java.sql.Timestamp
| oracle.sql.TIMESTAMPLTZ
|
