2023年7月13日发(作者：)

SQLServer与Oracle数据类型的对应关系关于SQL Server与Oracle数据类型的对应关系可以通过下⾯的语句进⾏查询

SELECT * type_mappings wheredbms_name='ORACLE';

类型ORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLESQL Sererbigintbinarybinarybitcharcharchardatedatetimedatetime2datetimeoffsetdecimaldouble precisionfloatgeographygeometryhierarchyidimageintmoneyncharncharntextnumericnvarcharnvarcharnvarchar(max)OracleNUMBERBLOBRAWNUMBERCHARCLOBVARCHAR2DATETIMESTAMPTIMESTAMPTIMESTAMP (7) WITH TIME ZONENUMBERFLOATFLOATBLOBBLOBBLOBBLOBNUMBERNUMBERNCHARNCLOBNCLOBNUMBERNCLOBNVARCHAR2NCLOB精度19NULL-11-1NULL-1NULL37NULL-1NULLNULLNULLNULLNULLNULL1019-1NULLNULL-1NULL-1NULL

340是否⽀持null值11111ORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLErealsmalldatetimesmallintsmallmoneysql_variantsysnametexttimetimestamptinyintuniqueidentifiervarbinaryvarbinaryvarbinary(max)varcharvarcharvarchar(max)xmlbigintbinarybinarybitcharcharchardatedatetimeREALDATENUMBERNUMBERNCLOBNVARCHAR2CLOBVARCHAR2RAWNUMBERCHARBLOBRAWBLOBCLOBVARCHAR2CLOBNCLOBNUMBERBLOBRAWNUMBERCHARCLOBVARCHAR2DATETIMESTAMPNULLNULL510NULL128NULL168338NULL-1NULLNULL-1NULLNULL19NULL-11-1NULL-1NULL34111111ORACLEORACLEORACLEORACLEORACLEORACLEdatetime2datetimeoffsetdecimaldouble precisionfloatgeographyTIMESTAMPTIMESTAMP (7) WITH TIME ZONENUMBERFLOATFLOATBLOB7NULL-1NULLNULLNULL4ORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEgeometryhierarchyidimageintmoneyncharncharntextnumericnvarcharnvarcharnvarchar(max)realsmalldatetimesmallintsmallmoneysql_variantsysnametexttimetimestamptinyintuniqueidentifiervarbinaryBLOBBLOBBLOBNUMBERNUMBERNCHARNCLOBNCLOBNUMBERNCLOBNVARCHAR2NCLOBREALDATENUMBERNUMBERNCLOBNVARCHAR2CLOBVARCHAR2RAWNUMBERCHARBLOBNULLNULLNULL1019-1NULLNULL-1NULL-1NULLNULLNULL510NULL128NULL168338NULL11ORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEvarbinaryvarbinary(max)varcharvarcharvarchar(max)xmlbigintbinarybinaryRAWBLOBCLOBVARCHAR2CLOBNCLOBNUMBERBLOBRAW-1NULLNULL-1NULLNULL19NULL-1411111ORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEbitcharcharchardatedatetimedatetime2datetimeoffsetdecimaldouble precisionfloatgeographygeometryhierarchyidimageintmoneyncharncharntextnumericnvarcharnvarcharnvarchar(max)realsmalldatetimesmallintsmallmoneysql_variantsysnametexttimetimestampNUMBERCHARCLOBVARCHAR2DATEVARCHAR2VARCHAR2VARCHAR2NUMBERFLOATFLOATBLOBBLOBBLOBBLOBNUMBERNUMBERCHARCLOBCLOBNUMBERCLOBVARCHAR2CLOBREALDATENUMBERNUMBERCLOBVARCHAR2CLOBVARCHAR2RAW1-1NULL-1NULL272734-1NULLNULLNULLNULLNULLNULL1019-1NULLNULL-1NULL-1NULLNULLNULL510NULL128NULLORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEtinyintuniqueidentifiervarbinaryvarbinaryvarbinary(max)varcharvarcharvarchar(max)xmlbigintbinarybinarybitcharcharchardatedatetimedatetime2datetimeoffsetdecimaldouble precisionfloatgeographygeometryhierarchyidimageintmoneyncharncharntextnumericnvarcharNUMBERCHARBLOBRAWBLOBCLOBVARCHAR2CLOBCLOBNUMBERBLOBRAWNUMBERCHARCLOBVARCHAR2DATETIMESTAMPTIMESTAMPTIMESTAMP (7) WITH TIME ZONENUMBERFLOATFLOATBLOBBLOBBLOBBLOBNUMBERNUMBERNCHARNCLOBNCLOBNUMBERNCLOB338NULL-1NULLNULL-1NULLNULL19NULL-11-1NULL-1NULL37NULL-1NULLNULLNULLNULLNULLNULL1019-1NULLNULL-1NULL3411111111ORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEORACLEnvarcharnvarcharnvarchar(max)realsmalldatetimesmallintsmallmoneysql_variantsysnametexttimetimestamptinyintuniqueidentifiervarbinaryvarbinaryNCLOBNVARCHAR2NCLOBREALDATENUMBERNUMBERNCLOBNVARCHAR2CLOBVARCHAR2RAWNUMBERCHARBLOBRAWNULL-1NULLNULLNULL510NULL128NULL168338NULL-134111111ORACLEORACLEORACLEORACLEORACLEvarbinary(max)varcharvarcharvarchar(max)xmlBLOBCLOBVARCHAR2CLOBNCLOBNULLNULL-1NULLNULL