CREATE TABLE T_DJ_NSRJBDJXX (
NSRLSH char(15) NOT NULL,
BBH char(8) NULL,
NSR_MC varchar(100) NULL,
NSR_PYM varchar(100) NULL,
NSRZCLX_DM varchar(20) NULL,
NSRDJLX_DM varchar(20) NULL,
NSRDJZT_DM varchar(20) NULL,
GJ_DM varchar(80) NULL,
HJD varchar(512) NULL,
ZGJG_DM char(11) NOT NULL,
ZSJG_DM char(11) NULL,
JCJG_DM char(11) NULL,
HSJG_DM char(11) NULL,
ZGKS_DM char(11) NULL,
HYDL_DM varchar(20) NULL,
HYXL_DM varchar(20) NULL,
ZYHYMS text NULL,
ZSFS_DM varchar(20) NULL,
SBFS_DM varchar(20) NULL,
SSGLY_DM varchar(30) NULL,
DKDJ_BJ char(1) DEFAULT '0' NULL,
WTDZDS_BJ char(1) DEFAULT '0' NULL,
SDH_BJ char(1) NULL,
ZDSY_BJ char(1) NULL,
SBH_BJ char(1) DEFAULT '0' NULL,
SZYF_BJ char(1) NULL,
PWF_BJ char(1) NULL,
LKSJGTJJJ_BJ char(1) NULL,
CBJ_BJ char(1) NULL,
LSDJ_BJ char(1) NULL,
KQJYDJ_BJ char(1) NULL,
WLJYDJ_BJ char(1) NULL,
WCJYDJ_BJ char(1) NULL,
YHZ_BJ char(1) NULL,
GDSGG_BJ char(1) NULL,
NGSDJ_BJ char(1) NULL,
GUOSDJ_BJ char(1) NULL,
SFXYH_BJ char(1) NULL,
JC_BJ char(1) NULL,
LSGX_DM varchar(20) NULL,
NSRSBH varchar(20) NULL,
ZZJGDM varchar(15) NULL,
SHBXH varchar(40) NULL,
FZRQ date NULL,
LR_SJ date NULL,
LRRY_DM varchar(30) NULL,
XG_SJ date NULL,
XGRY_DM varchar(30) NULL,
SPZT char(3) NULL,
NSRSZJX varchar(20) NULL,
SWDJZH varchar(30) NULL,
NSRLSH_RIGHT6 AS right(NSRLSH,6) materialized,
QRBJ char(1) DEFAULT '0' NOT NULL,
FP_BJ char(1) NULL,
FPZGDH_ZZRQ date NULL,
HJNSR_BJ char(1) NULL,
YHMM varchar(20) NULL,
ZCDZ varchar(200) NULL,
QYSDSZGJG varchar(2) NULL,
SBBLX varchar(2) NULL,
CWBBLX varchar(2) NULL,
FRDB varchar(20) NULL,
SSHY varchar(2) NULL,
ZZSLX varchar(2) NULL,
QYCYRS numeric(6,0) NULL,
ZCZE numeric(18,2) NULL,
SQLZGZZE numeric(18,2) NULL,
ZSFS varchar(2) NULL
);
这是用sybase导出来的建表语句,我要将他导入Oracle中,建表中红色代码如何改正?
NSRLSH_RIGHT6 AS right(NSRLSH,6) materialized 就这句。
将它转换成oracle可以识别的类型
NSRLSH char(15) NOT NULL,
BBH char(8) NULL,
NSR_MC varchar(100) NULL,
NSR_PYM varchar(100) NULL,
NSRZCLX_DM varchar(20) NULL,
NSRDJLX_DM varchar(20) NULL,
NSRDJZT_DM varchar(20) NULL,
GJ_DM varchar(80) NULL,
HJD varchar(512) NULL,
ZGJG_DM char(11) NOT NULL,
ZSJG_DM char(11) NULL,
JCJG_DM char(11) NULL,
HSJG_DM char(11) NULL,
ZGKS_DM char(11) NULL,
HYDL_DM varchar(20) NULL,
HYXL_DM varchar(20) NULL,
ZYHYMS text NULL,
ZSFS_DM varchar(20) NULL,
SBFS_DM varchar(20) NULL,
SSGLY_DM varchar(30) NULL,
DKDJ_BJ char(1) DEFAULT '0' NULL,
WTDZDS_BJ char(1) DEFAULT '0' NULL,
SDH_BJ char(1) NULL,
ZDSY_BJ char(1) NULL,
SBH_BJ char(1) DEFAULT '0' NULL,
SZYF_BJ char(1) NULL,
PWF_BJ char(1) NULL,
LKSJGTJJJ_BJ char(1) NULL,
CBJ_BJ char(1) NULL,
LSDJ_BJ char(1) NULL,
KQJYDJ_BJ char(1) NULL,
WLJYDJ_BJ char(1) NULL,
WCJYDJ_BJ char(1) NULL,
YHZ_BJ char(1) NULL,
GDSGG_BJ char(1) NULL,
NGSDJ_BJ char(1) NULL,
GUOSDJ_BJ char(1) NULL,
SFXYH_BJ char(1) NULL,
JC_BJ char(1) NULL,
LSGX_DM varchar(20) NULL,
NSRSBH varchar(20) NULL,
ZZJGDM varchar(15) NULL,
SHBXH varchar(40) NULL,
FZRQ date NULL,
LR_SJ date NULL,
LRRY_DM varchar(30) NULL,
XG_SJ date NULL,
XGRY_DM varchar(30) NULL,
SPZT char(3) NULL,
NSRSZJX varchar(20) NULL,
SWDJZH varchar(30) NULL,
NSRLSH_RIGHT6 AS right(NSRLSH,6) materialized,
QRBJ char(1) DEFAULT '0' NOT NULL,
FP_BJ char(1) NULL,
FPZGDH_ZZRQ date NULL,
HJNSR_BJ char(1) NULL,
YHMM varchar(20) NULL,
ZCDZ varchar(200) NULL,
QYSDSZGJG varchar(2) NULL,
SBBLX varchar(2) NULL,
CWBBLX varchar(2) NULL,
FRDB varchar(20) NULL,
SSHY varchar(2) NULL,
ZZSLX varchar(2) NULL,
QYCYRS numeric(6,0) NULL,
ZCZE numeric(18,2) NULL,
SQLZGZZE numeric(18,2) NULL,
ZSFS varchar(2) NULL
);
这是用sybase导出来的建表语句,我要将他导入Oracle中,建表中红色代码如何改正?
NSRLSH_RIGHT6 AS right(NSRLSH,6) materialized 就这句。
将它转换成oracle可以识别的类型
数字型用number
时间也是用date
NSRLSH_RIGHT6 AS right(NSRLSH,6) materialized
NSRLSH_RIGHT6不要这个列 oracle不支持
就是在你要用到的时候用substr(NSRLSH,6)这样就好了