Oracle与java.sql.Types的对应
Oracle java.sql.Types
blob blob
char char
clob clob
date date
number decimal
long varbinary
nclob,nvarchar2 other
smallint smallint
timestamp timstamp
raw varbinary
varchar2 varchar
Sql server与java.sql.Types的对应
Sql server java.sql.Types
bigint (2005,2008) bigint
timstamp,binary binary
bit bit
char,nchar,unqualified char
datetime date
money,smallmoney,decimal decimal
float (2005,2008) double
float(2000) float
int integer
image longvarbinary
text,ntext,xml longvarchar
numeric numeric
real real
smallint smallint
datetime,smalldatetime timestamp
tinyint tinyint
varbinary varbinay
nvarchar,varchar varchar
DB2与java.sql.Types的对应
bigint bigint
blob blob
character,graphic char
clob clob
date date
decimal decimal
double double
integer integer
longvargraphic longvarchar
longvarchar
real real
smallint smallint
time time
timestamp timestamp
vargraphic varchar
varchar
MySQL与java.sql.Types的对应
MySQL java.sql.Types
bigint bigint
tinyblob binary
bit bit
enum,set,char char
date,year date
decimal,numeric decimal
double,real double
mediumint,int integer
blob,mediumblob blob
longblob
float real
smallint smallint
time time
timestamp,datetime timestamp
tinyint tinyint
varbinary,binary varbinay
varchar,tinytext,text varchar
Sybase与java.sql.Types的对应
Sybase java.sql.Types
binary binary
bit bit
char,nchar, char
money,smallmoney,decimal decimal
float double
int integer
image longvarbinary
text longvarchar
numeric numeric
real real
smallint smallint
datetime,smalldatetime timestamp
tinyint tinyint
varbinar,timestamp varbinay
nvarchar,varchar ,sysname varchar
转载 michzel的空间
分享到:
相关推荐
oracle-instantclient-basic-11.1.0.1-1.x86_64.rpm
oracle ora-各种常见java.sql.SQLException归纳
oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm --补充包/文件,是为了运行sql*plus的即时客户端; oracle-instantclient11.2-odbc-11.2.0.4.0-1.x86_64.rpm --补充包/文件,为运行ODBC环境附加库; ...
oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm --补充包/文件,是为了运行sql*plus的即时客户端; oracle-instantclient11.2-odbc-11.2.0.4.0-1.x86_64.rpm --补充包/文件,为运行ODBC环境附加库; ...
基于java的开发源码-Oracle数据库工具 WARTS.zip 基于java的开发源码-Oracle数据库工具 WARTS.zip 基于java的开发源码-Oracle数据库工具 WARTS.zip 基于java的开发源码-Oracle数据库工具 WARTS.zip 基于java的开发...
在oracle里面运行一下,解决Exception java.sql.SQLException ORA-00600 内部错误代码
Oracle数据库应用培训--使用SQL.zipPlus工具.pptx
Oracle数据库安装在RedHat Linux Enterprise操作系统下oracleasm-2.6.18-308.el5-2.0.5-1.el5.i686.rpm
Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications instantclient-basic-windows.x64-11.2.0.4.0.zip (54,956,947 bytes) Instant Client 程序包 — Basic(win64...
oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.rpm client 安装包 rpm -> deb : sudo alien xxx.rpm
oracle即时客户端 instantclient-basic-linux.x64-11.2.0.4.0.zip
S2-Java-企业数据库Oracle应用.docx
驱动 对应数据库 ---------------------------------------------------------- ojdbc14.jar oracle10g oracle9i ---------------------------------------------------------- sqljdbc.jar SQLServer2000 SQL...
CentOS6.6安装oracle asm工具依赖的rpm
循序渐进Oracle----数据库管理、优化与备份恢复.pdf
Oracle的oci包,最新版instantclient-basic-windows.x64-11.2.0.4.0,支持11g。
oracle instantclient-basic-windows.x64-12.1.0.2.0
大型数据库概论 Introduction of Large Database 实验1 Oracle9i安装配置与基本操作 H155-合集-大型数据库系统概论-实验全文共24页,当前为第1页。 【实验目的】 1. 掌握Oracle9i服务器和客户端软件的安装配置方法。...